Manual:Category table

Track all existing categories. Something is a category if 1) it has an entry somewhere in categorylinks, or 2) it once did. Categories might not have corresponding pages, so they need to be tracked separately.

DESCRIBE category

Fields:


 * cat_id : Primary key
 * cat_title : Name of the category, in the same form as page_title (with underscores). If there is a category page corresponding to this category, by definition, it has this name (in the Category namespace).
 * cat_pages : Number of pages in the category
 * cat_subcats : Number of sub-categories in the category
 * cat_files : Number of files in the category
 * cat_hidden : Reserved for future use

The number fields are signed to make underflow more obvious. We make the first number include the second two for better sorting: subtracting for display is easy, adding for ordering is not.

If the information in this table is incorrect, run the maintenance script populateCategory.php, if neccessary with the --force option.

Previous Versions
DESCRIBE category