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