States
| Column | Data Type | Data description | Package required | Key | Data Set | Join On |
|---|---|---|---|---|---|---|
| ID | int(11) | Unique ch-aviation created state ID | Airports | Primary | ||
| Country ISO | char(2) | ISO 3166-1 Alpha-2 country code | Airports | Unique/Foreign | Countries | Country ISO |
| Country Name | varchar(255) | Country name | Airports | |||
| State ISO | char(2) | ISO 3166-2 Alpha-2 subdivision code (used for states) | Airports | Unique | ||
| State Name | varchar(255) | State name | Airports |