## Accommodations

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

## Customers

customer_id | firstName | lastName | email | 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

## Reviews

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

## Employees

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

## Bookings

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