## City

id | name
--- | ---
1 | New York
2 | Los Angeles
3 | Chicago
4 | Houston
5 | Phoenix

## Hotel

id | name | address | city_id
--- | --- | --- | ---
|  |  | (→ City.id)
1 | The Plaza | Central Park South, New York, NY 10019 | 1
2 | Beverly Wilshire | 9500 Wilshire Blvd., Beverly Hills, CA 90212 | 2
3 | Palmer House Hilton | 17 E Monroe St., Chicago, IL 60603 | 3
4 | Marriott Marquis Houston | 1777 Walker St., Houston, TX 77010 | 4
5 | Fairmont Scottsdale Princess | 7575 East Princess Dr., Phoenix, AZ 85054 | 5

## RoomType

id | hotel_id | type | price
--- | --- | --- | ---
| (→ Hotel.id) |  |
1 | 1 | Standard | 250
2 | 1 | Deluxe | 300
3 | 2 | Luxury Suite | 700
4 | 3 | Executive Suite | 400
5 | 4 | Family Suite | 250
6 | 5 | Garden View | 200

## LeisureFeature

id | feature
--- | ---
1 | Swimming Pool
2 | Hot Tub

## FeatureInRoom

id | roomtype_id | leisurefeature_id
--- | --- | ---
| (→ RoomType.id) | (→ LeisureFeature.id)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 1
4 | 4 | 2
5 | 5 | 1

## Reservation

id | checkin_date | checkout_date | roomtype_id | customer_name | guest_count
--- | --- | --- | --- | --- | ---
|  |  | (→ RoomType.id) |  |
1 | 2023-01-01 | 2023-01-05 | 1 | John Doe | 2
2 | 2023-01-10 | 2023-01-15 | 2 | Jane Smith | 3
3 | 2023-02-01 | 2023-02-05 | 3 | Alice Johnson | 1
4 | 2023-02-10 | 2023-02-15 | 4 | Bob Brown | 2
5 | 2023-03-01 | 2023-03-05 | 5 | Carol White | 1