User:Chughakshay16/conferencetable

From mediawiki.org

Fields[edit]

conf_id[edit]

This is the primary key for this table.This key would be referenced by many other tables which such as events, pages and some more.

conf_title[edit]

This will define the title of the conference. This value would be set by the admin during the conference setup and this is the same title which will be used as $par in the Special Page (Special:Dashboard/<conference-title>). This title will also be used for marking the title on the main page of the conference.There can't be two conferences with the same title. All the pages for the conference will have conference title prefixed in their title.

conf_begin_date[edit]

This is the begin date of the conference as entered by the admin. Code will use start_date and end_date to figure out the number of days for the conference.

conf_end_date[edit]

This is the end date of the conference.

conf_descr[edit]

This is the description which will be shown on the main page of the conference. And this value is also entered by the admin during the setup.

conf_venue[edit]

This defines the venue for the conference. Besides using it on the pages with the help of magic word such as {{VENUE}} it wont be of any use.

conf_capacity[edit]

This defines the upper limit for the number of attendees for the conference. Once the limit is crossed a notice would be shown on the registration page that the registration is closed for the conference. If the admin wants he/she can later change this value depending on the situation.

Schema summary[edit]

DESCRIBE conferences; :

+-----------------------+---------------------+------+-----+---------+----------------+
| Field                 | Type                | Null | Key | Default | Extra          |
+-----------------------+---------------------+------+-----+---------+----------------+
| conf_id               | int(8) unsigned     | NO   | PRI | NULL    | auto_increment |
| conf_title            | varbinary(255)      | NO   | UNI | NULL    |                |
| conf_begin_date       | timestamp           | NO   |     | NULL    |                |
| conf_end_date         | timestamp           | NO   |     | NULL    |                |
| conf_descr            | tinyblob            | NO   |     | NULL    |                |
| conf_venue            | varbinary(255)      | NO   |     | NULL    |                |
| conf_capacity         | int(4) unsigned     | NO   |     | 0       |                |
+-----------------------+---------------------+------+-----+---------+----------------+