## 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