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    |                |
+-----------------------+---------------------+------+-----+---------+----------------+