Extension:PageTriage/pagetriage page tags table
Appearance
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
.