| Column |
Data Type |
Data description |
Package required |
Key |
Data Set |
Join On |
| ID |
int(11) |
Unique ch-aviation created metro group ID |
Airports |
Primary |
|
|
| Metro_Group |
char(3) |
Metro Group IATA three-character code |
Airports |
Unique |
|
|
| Description |
varchar(255) |
Metro Group description |
Airports |
|
|
|
| State Name |
varchar(255) |
State name |
Airports |
|
|
|
| State ISO |
char(2) |
ISO 3166-2 Alpha-2 subdivision code (used for states) |
Airports |
Foreign |
States |
State ISO |
| Country Name |
varchar(255) |
Country name |
Airports |
|
|
|
| Country ISO |
char(2) |
ISO 3166-1 Alpha-2 country code |
Airports |
Foreign |
Countries |
Country ISO |
| Airport Count |
int(11) |
Number of airports located in the metro group |
Airports |
|
|
|
