Difference between revisions of "Guest House"

From SQLZOO
Jump to: navigation, search
(=booking)
Line 1: Line 1:
 
Managing bookings for a small hotel.
 
Managing bookings for a small hotel.
 
+
[[File:hotel.png]]
 
===booking===
 
===booking===
 
This table contains an entry for every booking made at the hotel.
 
This table contains an entry for every booking made at the hotel.

Revision as of 19:34, 26 July 2016

Managing bookings for a small hotel. Hotel.png

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