RoomTypes

IDNameLobbyTerrace
1SingleYesNo
2DoubleNoYes
3SuiteYesYes

Rooms

IDTypeIDSize
(→ RoomTypes.ID)
11500.0
21600.0
32700.0
43800.0

Guests

IDFirstNameLastNameEmail
1JohnDoejohn@example.com
2JaneSmithjane@example.com
3AliceBrownalice@example.com
4BobWhitebob@example.com

Reservations

IDRoomIDCheckInDateCheckOutDateGuestID
(→ Rooms.ID)(→ Guests.ID)
112022-01-012022-01-051
222022-01-062022-01-102
332022-01-112022-01-153
442022-01-162022-01-204