User:Chughakshay16/pagestable

From mediawiki.org
Jump to navigation Jump to search

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