Locations
LocationID | Name |
1 | Snowdonia |
2 | Lake District |
Accommodations
AccommodationID | Type |
1 | Glamping Pod |
2 | Treehouse |
Rooms
RoomID | LocationID | AccommodationID |
| (→ Locations.LocationID) | (→ Accommodations.AccommodationID) |
1 | 1 | 1 |
2 | 1 | 2 |
3 | 2 | 1 |
4 | 2 | 2 |
Customers
CustomerID | FirstName | LastName | Email |
1 | John | Doe | john@example.com |
2 | Jane | Smith | jane@example.com |
Bookings
BookingID | RoomID | CustomerID | CheckInDate | CheckOutDate |
| (→ Rooms.RoomID) | (→ Customers.CustomerID) | | |
1 | 1 | 1 | 2022-07-01 | 2022-07-08 |
2 | 2 | 2 | 2022-07-15 | 2022-07-22 |
3 | 3 | 1 | 2022-08-01 | 2022-08-08 |
4 | 4 | 2 | 2022-08-15 | 2022-08-22 |