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

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