Extension:PageTriage/pagetriage page tags table
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
editptrpt_page_id
editThis is the key for the page we are recording metadata about.
ptrpt_tag_id
editThis is the key to pagetriage_tags.ptrt_tag_id
.
ptrpt_value
editThis 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
.