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. |
Category:Wikimedia extension database tables#pagetriage tags%20table
