Apartments

idnametypecity
1High-end ResidentialResidentialNew York
2Luxury HotelHotelLos Angeles

Rooms

idapartment_idnumberfloor_number
(→ Apartments.id)
111012
223017

Guests

idfirst_namelast_nameemailphone_number
1JohnDoejohn@example.com1234567890
2JaneSmithjane@example.com0987654321

Orders

order_idguest_idroom_idorder_datetotal_amountstatus
(→ Guests.id)(→ Rooms.id)
1112024-03-13 17:20:34150.0Pending
2222024-03-13 17:20:34200.0Completed

Espresso_Machine

idapartment_idmodelbrandprice
(→ Apartments.id)
11Model ABrand XYZ300.0
22Model BBrand ABC250.0

Blender

idapartment_idmodelbrandprice
(→ Apartments.id)
11Model PPrestige Brands Inc.150.0
22Model QQuality Appliances LLC120.0