id | name |
---|---|
1 | Snowdonia |
2 | Lake District |
id | typeName |
---|---|
1 | Standard Pod |
2 | Deluxe Pod |
id | podNumber | capacity | locationId | accommodationTypeId |
---|---|---|---|---|
(→ Location.id) | (→ AccommodationType.id) | |||
1 | 1 | 2 | 1 | 1 |
2 | 2 | 3 | 1 | 1 |
3 | 3 | 2 | 1 | 2 |
4 | 4 | 4 | 2 | 2 |
5 | 5 | 6 | 2 | 2 |
id | houseNumber | capacity | locationId | accommodationTypeId |
---|---|---|---|---|
(→ Location.id) | (→ AccommodationType.id) | |||
1 | 101 | 6 | 1 | 1 |
2 | 102 | 8 | 1 | 1 |
3 | 103 | 6 | 2 | 1 |
4 | 104 | 8 | 2 | 2 |
5 | 105 | 6 | 2 | 2 |
id | guestID | glampingPodId | checkInDate | checkOutDate | totalPrice |
---|---|---|---|---|---|
(→ Guest.id) | (→ GlampingPod.id) | ||||
1 | 1 | 1 | 2022-09-01 | 2022-09-07 | 500 |
2 | 2 | 2 | 2022-09-15 | 2022-09-21 | 700 |
3 | 3 | 3 | 2022-09-01 | 2022-09-07 | 500 |
4 | 4 | 4 | 2022-09-15 | 2022-09-21 | 700 |
5 | 5 | 5 | 2022-09-01 | 2022-09-07 | 500 |
id | firstName | lastName | phoneNumber | |
---|---|---|---|---|
1 | John | Doe | john.doe@example.com | +441234567890 |
2 | Jane | Smith | jane.smith@example.com | +449876543210 |
3 | Alice | Brown | alice.brown@example.com | +441234567891 |
4 | Charlie | Black | charlie.black@example.com | +449876543211 |
5 | David | White | david.white@example.com | +441234567892 |