| 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 |