| id | name |
|---|---|
| 1 | New York |
| 2 | Los Angeles |
| 3 | Chicago |
| 4 | Houston |
| 5 | Phoenix |
| 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 |
| 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 |
| id | feature |
|---|---|
| 1 | Swimming Pool |
| 2 | Hot Tub |
| id | roomtype_id | leisurefeature_id |
|---|---|---|
| (→ RoomType.id) | (→ LeisureFeature.id) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | 1 |
| 4 | 4 | 2 |
| 5 | 5 | 1 |
| 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 |