Room
id | Name | Indoor_Outdoor_Space | Size | Price |
1 | Conference Hall | Lobby | 500 | 678.99 |
2 | Banquet Hall | Lobby | 600 | 830.99 |
3 | Rooftop Terrace | Terrace | 500 | 1000.99 |
4 | Garden Patio | Terrace | 400 | 870.99 |
Amenities
id | amenityName | available |
1 | WiFi | 1 |
2 | Parking Space | 1 |
3 | Air Conditioner | 1 |
4 | Projector | 0 |
Booking
bookingID | roomId | customerId | startDate | endDate | totalPrice |
| (→ Room.id) | (→ Customer.customerID) | | | |
1 | 1 | 1 | 2022-01-10 | 2022-01-12 | 2000 |
2 | 2 | 2 | 2022-01-15 | 2022-01-17 | 3000 |
3 | 3 | 3 | 2022-01-20 | 2022-01-22 | 4000 |
4 | 4 | 4 | 2022-01-25 | 2022-01-27 | 5000 |
Customer
customerID | firstName | lastName | email | phoneNumber |
1 | John | Doe | john@example.com | +123456789 |
2 | Jane | Smith | jane@example.com | +234567890 |
3 | Michael | Johnson | michael@example.com | +345678901 |
4 | Emily | Williams | emily@example.com | +45678902 |