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