id | startTime | endTime |
---|---|---|
1 | 7:30 AM | 4 PM |
2 | 8:00 AM | 12 PM |
id | name | location | hoursId |
---|---|---|---|
(→ Hours.id) | |||
1 | Morning Delight | Hotel A Lobby | 1 |
2 | Gourmet Corner | Conference Center | 2 |
id | name | location | hoursId |
---|---|---|---|
(→ Hours.id) | |||
1 | Aroma Cafe | Lobby of Hotel A | 1 |
2 | Espresso Station | Convention Center | 2 |
id | name | location | type | hoursId |
---|---|---|---|---|
(→ Hours.id) | ||||
1 | La Cucina Italiana | Hotel A Ground Floor | Italian | 1 |
2 | Oriental Palace | Conference Center | Chinese | 2 |
id | name | location | hoursId |
---|---|---|---|
(→ Hours.id) | |||
1 | The Wine Cellar | Hotel A Basement | 1 |
2 | Rooftop Bar | Convention Center Top Floor | 2 |
id | hotelId | roomNumber | price |
---|---|---|---|
(→ Hotels.id) | |||
1 | 1 | Room 101 | 199.99 |
2 | 2 | Suite 202 | 299.99 |
3 | 1 | Family Suite | 249.99 |
4 | 2 | Corner Room | 269.99 |
5 | 1 | Deluxe King | 199.99 |