Extension:PageTriage/pagetriage tags table
mysql> describe pagetriage_tags; +---------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+----------------+ | ptrt_tag_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ptrt_tag_name | varbinary(20) | NO | UNI | NULL | | | ptrt_tag_desc | varbinary(255) | NO | | NULL | | +---------------+------------------+------+-----+---------+----------------+
PageTriage keeps data for some pages, called "tags". On the English Wikipedia, as of May 17, 2021, the following 21 tags are used. Other Wikipedias do not have PageTriage installed.
ptrt_tag_id | ptrt_tag_name | ptrt_tag_desc |
---|---|---|
1 | linkcount | Number of inbound links |
2 | category_count | Category mapping count |
3 | csd_status | CSD status |
4 | prod_status | PROD status |
5 | blp_prod_status | BLP PROD status |
6 | afd_status | AFD status |
7 | rev_count | Number of edits to the article |
8 | page_len | Number of bytes of article |
9 | snippet | Beginning of article snippet |
10 | user_name | User name |
11 | user_editcount | User total edit |
12 | user_creation_date | User registration date |
13 | user_autoconfirmed | Check if user is autoconfirmed |
14 | user_bot | Check if user is in bot group |
15 | user_block_status | Check if user is blocked site-wide |
16 | user_id | User id |
17 | reference | Check if page has references |
18 | user_experience | Experience level: newcomer, learner, experienced or anonymous |
19 | copyvio | Latest revision ID that has been tagged as a likely copyright violation, if any |
20 | afc_state | The submission state of drafts |
21 | recreated | Check if the page has been previously deleted. |