Guests

guest_idfirst_namelast_nameemailphone_number
1JohnDoejohn.doe@example.com1234567890
2JaneSmithjane.smith@example.com0987654321

Rooms

room_idroom_typepricecapacity
(→ RoomTypes.type_name)
1Standard Double80.02
2Deluxe Twin120.02

RoomTypes

type_namedescription
SingleA small room with one bed.
SuiteA spacious room with a separate living area.

Bookings

booking_idcheck_incheck_outguest_idroom_idtotal_price
(→ Guests.guest_id)(→ Rooms.room_id)
12021-10-012021-10-0511320.0
22021-10-102021-10-1422440.0

FoodServices

service_idfood_servicecuisine_id
(→ Cuisines.cuisine_id)
1Restaurant1
2Restaurant2
3Café1
4Café2

Cuisines

cuisine_idname
1Italian
2Mexican