User:Chughakshay16/locationstable

From mediawiki.org
Jump to navigation Jump to search

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[edit]

location_id[edit]

Primary key for this table.

room_no[edit]

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

location_descr[edit]

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[edit]

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

Schema summary[edit]

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