Extension:PageTriage/pagetriage page tags table

From mediawiki.org
mysql> describe pagetriage_page_tags;
+---------------+------------------+------+-----+---------+-------+
| Field         | Type             | Null | Key | Default | Extra |
+---------------+------------------+------+-----+---------+-------+
| ptrpt_page_id | int(10) unsigned | NO   | PRI | NULL    |       |
| ptrpt_tag_id  | int(10) unsigned | NO   | PRI | NULL    |       |
| ptrpt_value   | varbinary(255)   | NO   |     | NULL    |       |
+---------------+------------------+------+-----+---------+-------+

PageTriage keeps data for some pages, called "tags". The list of tags is located in the pagetriage_tags table. This table stores the tag_id and its value.

Fields[edit]

ptrpt_page_id[edit]

This is the key for the page we are recording metadata about.

ptrpt_tag_id[edit]

This is the key to pagetriage_tags.ptrt_tag_id.

ptrpt_value[edit]

This is the value to store for the tag. For example, if we are storing linkcount for a page with 10 inbound links, the value would be 10.