Difference between revisions of "Guest House"
(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 | | +---------------------+------------+------+-----+---------+-------+
