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.
Fields
[edit]page_conf_id
[edit]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
[edit]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
[edit]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
[edit]This value would be the one set by the admin, and this would be same to the page_namespace(page table).
page_conf_title
[edit]This value would also be set the admin , and this would be same to the page_title(page table).
Schema summary
[edit]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 | | +-----------------------+---------------------+------+-----+---------+----------------+