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.

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