## RoomTypes

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

## Reservations

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

## Payments

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

## CruiseShips

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

## Ports

name | country
--- | ---
PortMiami | USA
World Trade Center Barcelona | Spain
Terminal Passeggeri di Venezia | Italy
Kowloon Dockyard | China
HarbourFront Centre | Singapore

## Cities

name | country
--- | ---
Miami | USA
Barcelona | Spain
Venice | Italy
Hong Kong | China
Singapore | Singapore