## Guests

guest_id | first_name | last_name | email | phone_number
--- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | 1234567890
2 | Jane | Smith | jane.smith@example.com | 0987654321

## Rooms

room_id | room_type | price | capacity
--- | --- | --- | ---
| (→ RoomTypes.type_name) |  |
1 | Standard Double | 80.0 | 2
2 | Deluxe Twin | 120.0 | 2

## RoomTypes

type_name | description
--- | ---
Single | A small room with one bed.
Suite | A spacious room with a separate living area.

## Bookings

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

## FoodServices

service_id | food_service | cuisine_id
--- | --- | ---
|  | (→ Cuisines.cuisine_id)
1 | Restaurant | 1
2 | Restaurant | 2
3 | Café | 1
4 | Café | 2

## Cuisines

cuisine_id | name
--- | ---
1 | Italian
2 | Mexican