User:Chughakshay16/eventstable

From mediawiki.org
Jump to navigation Jump to search

The events table holds the information about all the events for a particular conference. The admin sets the events during the conference setup, and with each event a location is attached as well.

Fields[edit]

event_id[edit]

Primary key for this table

event_conf_id[edit]

Reference to the conference for which this event was set.

event_start_time[edit]

The starting time of the conference.

event_end_time[edit]

The ending time of the conference

event_date[edit]

The date on which this event is held.

event_location_id[edit]

The location for this conference.This field refers to a row in locations table. More than one event can point to the same location but not at the same time.

event_topic[edit]

The topic for that event. A sort of a brief description which would be displayed in the schedule of the conference.

event_group[edit]

This is the group that can attend this event.

Schema summary[edit]

DESCRIBE events; :

+-----------------------+---------------------+------+-----+---------+----------------+
| Field                 | Type                | Null | Key | Default | Extra          |
+-----------------------+---------------------+------+-----+---------+----------------+
| event_id              | int(8) unsigned     | NO   | PRI | NULL    | auto_increment |
| event_conf_id         | int(8) unsigned     | NO   |     | NULL    |                |
| event_start_time      | datetime            | NO   |     | NULL    |                |
| event_end_time        | datetime            | NO   |     | NULL    |                |
| event_location_id     | int(8) unsigned     | NO   |     | NULL    |                |
| event_topic           | varchar(45)         | NO   |     | NULL    |                |
| event_group           | varbinary(16)       | NO   |     | NULL    |                |
+-----------------------+---------------------+------+-----+---------+----------------+