guest_id | first_name | last_name | phone_number | |
---|---|---|---|---|
1 | John | Doe | john.doe@example.com | 1234567890 |
2 | Jane | Smith | jane.smith@example.com | 0987654321 |
room_id | room_type | price | capacity |
---|---|---|---|
(→ RoomTypes.type_name) | |||
1 | Standard Double | 80.0 | 2 |
2 | Deluxe Twin | 120.0 | 2 |
type_name | description |
---|---|
Single | A small room with one bed. |
Suite | A spacious room with a separate living area. |
booking_id | check_in | check_out | guest_id | room_id | total_price |
---|---|---|---|---|---|
(→ Guests.guest_id) | (→ Rooms.room_id) | ||||
1 | 2021-10-01 | 2021-10-05 | 1 | 1 | 320.0 |
2 | 2021-10-10 | 2021-10-14 | 2 | 2 | 440.0 |
service_id | food_service | cuisine_id |
---|---|---|
(→ Cuisines.cuisine_id) | ||
1 | Restaurant | 1 |
2 | Restaurant | 2 |
3 | Café | 1 |
4 | Café | 2 |
cuisine_id | name |
---|---|
1 | Italian |
2 | Mexican |