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 every event a location is attached as well.

event_id
Primary key for this table

event_conf_id
Reference to the conference for which this event was set.

event_start_time
The starting time of the conference.

event_end_time
The ending time of the conference

event_date
The date on which this event is held.

event_location_id
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
The topic for that event. A sort of a brief description which would be displayed in the schedule of the conference.

event_group
This is the group that can attend this event.

Schema summary
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    |                |