id | typeName | capacity | pricePerNight |
---|---|---|---|
1 | Standard | 3 | 100.99 |
2 | Deluxe | 4 | 150.99 |
3 | Suite | 6 | 200.99 |
4 | Family Suite | 7 | 250.99 |
5 | Executive Suite | 8 | 300.99 |
id | customerId | roomTypeId | checkInDate | checkOutDate |
---|---|---|---|---|
(→ Customers.id) | (→ RoomTypes.id) | |||
1 | 1 | 1 | 2022-06-01 | 2022-06-05 |
2 | 2 | 2 | 2022-06-05 | 2022-06-10 |
3 | 3 | 3 | 2022-06-10 | 2022-06-14 |
4 | 4 | 4 | 2022-06-14 | 2022-06-18 |
5 | 5 | 5 | 2022-06-18 | 2022-06-22 |
id | reservationId | amountPaid | paymentMethod | transactionTime |
---|---|---|---|---|
(→ Reservations.id) | ||||
1 | 1 | 300 | Credit Card | 2022-06-01 10:00:00 |
2 | 2 | 600 | Debit Card | 2022-06-05 14:00:00 |
3 | 3 | 900 | PayPal | 2022-06-10 08:00:00 |
4 | 4 | 1200 | Wire Transfer | 2022-06-14 12:00:00 |
5 | 5 | 1500 | Cash | 2022-06-18 16:00:00 |
port | city | shipName | maxCapacity |
---|---|---|---|
(→ Ports.name) | (→ Cities.name) | ||
PortMiami | Miami | Queen Mary II | 2620 |
World Trade Center Barcelona | Barcelona | Allure of the Seas | 5400 |
Terminal Passeggeri di Venezia | Venice | Seabourn Odyssey | 458 |
Kowloon Dockyard | Hong Kong | Golden Era | 1400 |
HarbourFront Centre | Singapore | Mariner of the Seas | 3804 |
name | country |
---|---|
PortMiami | USA |
World Trade Center Barcelona | Spain |
Terminal Passeggeri di Venezia | Italy |
Kowloon Dockyard | China |
HarbourFront Centre | Singapore |
name | country |
---|---|
Miami | USA |
Barcelona | Spain |
Venice | Italy |
Hong Kong | China |
Singapore | Singapore |