User:Chughakshay16/conferencetable

Fields

conf_id

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

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

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

This is the end date of the conference.

conf_descr

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

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

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

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