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