Airlines
airline_id | name |
1 | Alaskan Airlines |
2 | Delta Airlines |
3 | United Airlines |
4 | Southwest Airlines |
5 | JetBlue Airlines |
Airplanes
airplane_id | model | capacity | current_flight |
| | | (→ Flights.flight_id) |
1 | Boeing 737 | 180 | None |
2 | Airbus A320 | 160 | None |
3 | Bombardier Q400 | 65 | None |
4 | Embraer E190 | 80 | None |
5 | Boeing 787 | 250 | None |
Flights
flight_id | departure_time | destination | airplane_id | airline_id |
| | | (→ Airplanes.airplane_id) | (→ Airlines.airline_id) |
1 | 2021-11-01 08:00:00 | Los Angeles | 1 | 1 |
2 | 2021-11-01 10:00:00 | New York | 2 | 2 |
3 | 2021-11-01 12:00:00 | Chicago | 3 | 3 |
4 | 2021-11-01 14:00:00 | Houston | 4 | 4 |
5 | 2021-11-01 16:00:00 | Dallas | 5 | 5 |
Passengers
passenger_id | first_name | last_name | age | family_id |
| | | | (→ Families.family_id) |
1 | John | Smith | 35 | 1 |
2 | Jane | Doe | 28 | None |
3 | Michael | Johnson | 45 | 2 |
4 | Emily | Williams | 30 | 3 |
5 | David | Brown | 50 | 4 |
Boardings
boarding_id | priority | family | passenger_id | flight_id |
| | | (→ Passengers.passenger_id) | (→ Flights.flight_id) |
1 | 1 | 1 | 1 | 1 |
2 | 0 | 0 | 2 | 2 |
3 | 0 | 1 | 3 | 3 |
4 | 0 | 0 | 4 | 4 |
5 | 0 | 0 | 5 | 5 |
Families
family_id | head_of_family |
| (→ Passengers.passenger_id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |