Difference between revisions of "Guest House"

From SQLZOO
Jump to: navigation, search
(Created page with "Managing bookings for a small hotel. ===booking== This table contains an entry for every booking made at the hotel. +---------------------+------------+------+-----+--------...")
 
(=booking)
Line 1: Line 1:
 
Managing bookings for a small hotel.
 
Managing bookings for a small hotel.
  
===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:33, 26 July 2016

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