User:Chughakshay16/pagestable

The pages table is where we store all the information about the pages created for the conference. Each entry in this table contains a link to the core page table, this way we can keep a track of all the changes made to a page. This provides an access point for extracting pages related to a particular conference.

page_conf_id
This is a foreign key to the conferences table. As each entry of this table would be attached to one of the conferences.This column can be used to extract all the pages for a particular conference.

page_ref_id
This is a foreign key to the core page table(page_id). This way we can associate all the other page features already present in the Mediawiki with the new conference pages created. All the restrictions for a page, and properties for a page can be modified through this field.

page_conf_type
There are various types of pages that can be created for a conference such as Welcome Page, Submission Page,. All such types will be stored within a PHP array in the code, and for each type a specific code would be present. So from this array a code would be used to fill this field.

page_conf_namespace
This value would be the one set by the admin, and this would be same to the page_namespace(page table).

page_conf_title
This value would also be set the admin, and this would be same to the page_title(page table).

Schema summary
DESCRIBE pages; : +---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field                | Type                | Null | Key | Default | Extra          |
 * page_conf_id         | int(8) unsigned     | NO   | UNI | NULL    |                |
 * page_ref_id          | int(8) unsigned     | NO   | UNI | NULL    |                |
 * page_conf_type       | int(5)              | NO   |     | NULL    |                |
 * page_conf_namespace  | int(11)             | NO   |     | NULL    |                |
 * page_conf_title      | varbinary(255)      | NO   |     | NULL    |                |