User:Chughakshay16/locationstable

The locations table would be used to store all the locations for all the conferences. Since it has got no column which refers to the conference_id of the conferences table so the entries from this table can only be fetched or updated with the help of events table. With join operations ,locations for a particular conference can be fetched.

Fields

location_id

Primary key for this table.

room_no

Room no of the location if at all specified , if not then room no wont be used on the pages.

location_descr

Description of this location , if in some cases room no is not specified then the description should be clear enough to point to a specific location.

location_image_url

Any url that needs to be displayed alongside the location description on a page.

Schema summary

DESCRIBE locations; :

+-----------------------+---------------------+------+-----+---------+----------------+
| Field                 | Type                | Null | Key | Default | Extra          |
+-----------------------+---------------------+------+-----+---------+----------------+
| location_id           | int(8) unsigned     | NO   | PRI | NULL    | auto_increment |
| room_no               | int(6) unsigned     | NO   |     | 0   |                |
| location_descr        | tinyblob            | NO   |     | NULL    |                |
| location_image_url    | varchar(200)        | NO   |     | NULL    |                |
+-----------------------+---------------------+------+-----+---------+----------------+