Apartments
id | name | type | city |
1 | High-end Residential | Residential | New York |
2 | Luxury Hotel | Hotel | Los Angeles |
Rooms
id | apartment_id | number | floor_number |
| (→ Apartments.id) | | |
1 | 1 | 101 | 2 |
2 | 2 | 301 | 7 |
Guests
id | first_name | last_name | email | phone_number |
1 | John | Doe | john@example.com | 1234567890 |
2 | Jane | Smith | jane@example.com | 0987654321 |
Orders
order_id | guest_id | room_id | order_date | total_amount | status |
| (→ Guests.id) | (→ Rooms.id) | | | |
1 | 1 | 1 | 2024-03-13 17:20:34 | 150.0 | Pending |
2 | 2 | 2 | 2024-03-13 17:20:34 | 200.0 | Completed |
Espresso_Machine
id | apartment_id | model | brand | price |
| (→ Apartments.id) | | | |
1 | 1 | Model A | Brand XYZ | 300.0 |
2 | 2 | Model B | Brand ABC | 250.0 |
Blender
id | apartment_id | model | brand | price |
| (→ Apartments.id) | | | |
1 | 1 | Model P | Prestige Brands Inc. | 150.0 |
2 | 2 | Model Q | Quality Appliances LLC | 120.0 |