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 airport

General information
columns
field description Type Unit associated date foreign table
id Unique identifier Integer
name name Text
Height Height Real m
IATA_Code IATA Code Text
Area Area Real m²
date_opened date Opened Date
ICAO_Code ICAO Code Text
id_location location foreign key city
id_city city foreign key city
number_of_passengers number of passangers Integer Si
id_region administrative division foreign key administrative division
id_country country foreign key country
date_number_of_passengers number of passengers date Date
id_continent continent foreign key continent
latitude latitude Coordinate °
longitude longitude Coordinate °
Website Website Text
id_type type foreign key type of airport
id_use use foreign key type use airport
id_location_division_1 administrative división location foreign key administrative division
id_location_Continent continent location foreign key continent
id_location_country country location foreign key country
Relations
description related table relationship table
airline/airport airline airline_airport
airport/entity entity airport_entity
Table in which FK is located
table field
aviation occurrence/airplane id_departure_airport
aviation occurrence/airplane id_destination_airport
airline/airport id_airport
airport/entity id_airport
airline id_airport_hub