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 |