Extension:PageTriage/pagetriage tags table

From mediawiki.org
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.