id | name | location | price | capacity | accommodation_type |
---|---|---|---|---|---|
1 | Glamping Pod | Snowdonia | 99.99 | 6 | Camping |
2 | Glamping Pod | Cornwall | 89.99 | 3 | Camping |
3 | Treehouse | Snowdonia | 179.99 | 5 | Hotel |
4 | Treehouse | Dorset | 149.99 | 4 | Hotel |
5 | Motel | Brighton | 59.99 | 10 | Lodging |
6 | Hostel | Edinburgh | 29.99 | 15 | Youth Hostel |
customer_id | firstName | lastName | phoneNumber | address | |
---|---|---|---|---|---|
1 | John | Smith | johnsmith@example.com | +44123456789 | London, UK |
2 | Jane | Doe | janedoe@example.com | +44987654321 | Manchester, UK |
3 | Alice | Wonderland | alicewonderland@example.com | +44555555555 | Cardiff, UK |
4 | Charlie | Brown | charliebrown@example.com | +4455555556 | Newcastle, UK |
review_id | rating | comment | date | customer_id |
---|---|---|---|---|
(→ Customers.customer_id) | ||||
1 | 5 | Great experience! | 2021-10-01 12:00:00 | 1 |
2 | 3 | Good but could be better | 2021-10-02 12:00:00 | 2 |
3 | 4 | Nice place, would come back. | 2021-10-03 12:00:00 | 3 |
4 | 5 | Fantastic stay, highly recommended! | 2021-10-04 12:00:00 | 4 |
employee_id | firstName | lastName | role | hireDate | salary |
---|---|---|---|---|---|
1 | Emma | Stone | Manager | 2021-06-01 | 45000.0 |
2 | Peter | Jackson | Housekeeper | 2021-07-01 | 30000.0 |
3 | Lucy | Garcia | Chef | 2021-08-01 | 35000.0 |
4 | David | Williams | Maintenance | 2021-09-01 | 28000.0 |
booking_id | checkInTime | checkOutTime | numberOfGuests | totalCost | customer_id | accommodation_id |
---|---|---|---|---|---|---|
(→ Customers.customer_id) | (→ Accommodations.id) | |||||
1 | 2021-10-10 10:00:00 | 2021-10-12 14:00:00 | 2 | 199.99 | 1 | 1 |
2 | 2021-10-15 10:00:00 | 2021-10-17 14:00:00 | 4 | 399.99 | 1 | 2 |
3 | 2021-10-20 10:00:00 | 2021-10-22 14:00:00 | 2 | 249.99 | 2 | 3 |
4 | 2021-10-25 10:00:00 | 2021-10-27 14:00:00 | 3 | 399.99 | 3 | 4 |