User:Chughakshay16/eventstable
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
editevent_id
editPrimary key for this table
event_conf_id
editReference to the conference for which this event was set.
event_start_time
editThe starting time of the conference.
event_end_time
editThe ending time of the conference
event_date
editThe date on which this event is held.
event_location_id
editThe 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
editThe topic for that event. A sort of a brief description which would be displayed in the schedule of the conference.
event_group
editThis is the group that can attend this event.
Schema summary
editDESCRIBE 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 | | +-----------------------+---------------------+------+-----+---------+----------------+