id | name |
---|---|
1 | JFK |
2 | LAX |
3 | ORD |
4 | YUL |
5 | CDG |
airport_id | hotel_name | price |
---|---|---|
(→ Airports.id) | ||
1 | Hilton | 250.0 |
1 | Marriott | 300.0 |
2 | Radisson | 280.0 |
3 | Hyatt | 350.0 |
4 | Accor | 270.0 |
5 | Novotel | 260.0 |
airport_id | pod_name | price |
---|---|---|
(→ Airports.id) | ||
1 | GoSleep | 150.0 |
1 | RestEZ | 160.0 |
2 | SnoozCruz | 190.0 |
3 | AirPOD | 170.0 |
4 | DreamPOD | 180.0 |
5 | SlumberPOD | 200.0 |
flight_number | origin_airport_id | destination_airport_id | departure_time | arrival_time | price |
---|---|---|---|---|---|
(→ Airports.id) | (→ Airports.id) | ||||
AA123 | 1 | 2 | 2022-12-01 10:00 | 2022-12-01 14:00 | 200.0 |
2 | 2 | 3 | 2022-12-01 12:00 | 2022-12-01 16:00 | 220.0 |
3 | 1 | 3 | 2022-12-02 10:00 | 2022-12-02 14:00 | 210.0 |
4 | 3 | 4 | 2022-12-02 12:00 | 2022-12-02 16:00 | 230.0 |
5 | 4 | 5 | 2022-12-03 10:00 | 2022-12-03 14:00 | 240.0 |
passenger_id | first_name | last_name | |
---|---|---|---|
1 | John | Smith | johnsmith@example.com |
2 | Jane | Doe | janedoe@example.com |
3 | Alice | Wonderland | alicewonderland@example.com |
4 | Bob | Builder | bobbuilder@example.com |
5 | Charlie | Sheen | charliesheen@example.com |
booking_id | passenger_id | flight_number | hotel_id | sleep_pod_id | checkin_date | checkout_date |
---|---|---|---|---|---|---|
(→ Passengers.passenger_id) | (→ Flights.flight_number) | (→ Hotels.id) | (→ SleepPods.id) | |||
1 | 1 | AA123 | 1 | None | 2022-12-01 | 2022-12-03 |
2 | 2 | BB456 | 2 | 1 | 2022-12-02 | 2022-12-04 |
3 | 3 | CC789 | 3 | 2 | 2022-12-03 | 2022-12-05 |
4 | 4 | DD012 | 4 | 3 | 2022-12-04 | 2022-12-06 |
5 | 5 | EE345 | 5 | 4 | 2022-12-05 | 2022-12-07 |