## Airlines

id | airline_name | alliance | independent_carrier
--- | --- | --- | ---
|  | (→ Alliances.id) | (→ Carriers.id)
1 | American Airlines | 1 | 0
2 | United Airlines | 0 | 1
3 | Delta Airlines | 1 | 0
4 | Southwest Airlines | 1 | 1
5 | JetBlue Airways | 0 | 1

## Aircrafts

id | model | seats
--- | --- | ---
1 | Airbus A320 | 180
2 | Boeing 777 | 360
3 | Embraer E190 | 100

## Flights

id | airport_departure | airport_arrival | airline_id | aircraft_model | departure_time | arrival_time
--- | --- | --- | --- | --- | --- | ---
| (→ Airports.id) | (→ Airports.id) | (→ Airlines.id) | (→ Aircrafts.id) |  |
1 | None | None | 1 | 1 | 2023-01-01 09:00:00 | 2023-01-01 12:00:00
2 | None | None | 2 | 2 | 2023-01-01 10:00:00 | 2023-01-01 14:00:00
3 | None | None | 3 | 3 | 2023-01-01 11:00:00 | 2023-01-01 15:00:00
4 | None | None | 4 | 1 | 2023-01-01 12:00:00 | 2023-01-01 16:00:00
5 | None | None | 5 | 2 | 2023-01-01 13:00:00 | 2023-01-01 17:00:00

## Alliances

id | alliance_name
--- | ---
1 | Star Alliance
2 | OneWorld
3 | SkyTeam

## Carriers

id | carrier_name
--- | ---
1 | Boeing
2 | Embraer
3 | Airbus