Guest House

From SQLZOO
Revision as of 19:32, 26 July 2016 by Andr3w (talk | contribs) (Created page with "Managing bookings for a small hotel. ===booking== This table contains an entry for every booking made at the hotel. +---------------------+------------+------+-----+--------...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Managing bookings for a small hotel.

=booking

This table contains an entry for every booking made at the hotel.

+---------------------+------------+------+-----+---------+-------+
| Field               | Type       | Null | Key | Default | Extra | 
+---------------------+------------+------+-----+---------+-------+
| booking_id          | int(11)    | NO   | PRI | NULL    |       |
| booking_date        | date       | YES  |     | NULL    |       |
| room_no             | int(11)    | YES  | MUL | NULL    |       |
| guest_id            | int(11)    | NO   | MUL | NULL    |       |
| occupants           | int(11)    | NO   |     | 1       |       |
| room_type_requested | varchar(6) | YES  | MUL | NULL    |       |
| nights              | int(11)    | NO   |     | 1       |       |
| arrival_time        | varchar(5) | YES  |     | NULL    |       |
+---------------------+------------+------+-----+---------+-------+