# Describe Tables¶

## page¶

has a row for each page.

• namespace=0 is for main pages
• namespace=6 is for file pages
• namespace=14 is for category pages

cl_from: is the page_id to which the category is being assigned. this page_id can represent a main page, a file page, or a category page.

cl_to: is the page_title of a category page. parent/child relationships between categories are inidcated by rows in which the cl_from page_id refers to a category page.

cl_type is one of [page, file, subcat] and indicates the type of page cl_from refers to.

### Types of edges¶

• file -> category
• page -> category
• category -> category

For example, the first row below indicates that

## page_props¶

pp_page is a page_id. rows that have pp_propname = 'hiddencat' are categories that are not shown at the bottom of pages. these are typically only interesting for wikipedia editors or admins.

# Take a peek at the table objects¶

Note that there are not primary keys or foreign keys. This is because the tables we are working with are views.