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