Portal | Español

Privacy & Cookies
We request your permission to obtain statistical data of your navigation in this web.
If you continue browsing we consider that you accept the use of cookies.

Review Cookies Policy

table airline

General information
columns
field description Type Unit associated date foreign table
id Unique identifier Integer
name name Text
id_airport_hub Hub foreign key airport
image image Text
date_Ceased_operations date Ceased operations Date
date_Commenced_operations date Commenced operations Date
IATA_Code IATA Code Text
ICAO_Code ICAO Code Text
id_city_Headquarters city Headquarters foreign key city
id_division_1_Headquarters administrative division Headquarters foreign key administrative division
id_country_Headquarters country Headquarters foreign key country
id_continent_Headquarters continent Headquarters foreign key continent
id_Country Country foreign key country
id_continent continent foreign key continent
id_Parent Parent foreign key entity
number_of_aircrafts number of aircrafts Integer
number_of_destinations number of destinations Integer
Website Website Text
Relations
description related table relationship table
airline/airport airport airline_airport
airline/alliance airline airline_alliance
airline/person person airline_person
airplane/user airplane airplane_user
Table in which FK is located
table field
aviation occurrence/airplane id_operator
airline/airport id_airline
airline/alliance id_airline
airline/alliance id_alliance
airline/person id_airline
airplane/user id_airline