This table provides geographical information, particularly for regions and countries. Each region rolls up to a country.
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
geography_id (PK) |
INTEGER | PK | Unique identifier for a state or region. | Yes |
region_id |
INTEGER | Unique identifier for a state or region. | No | |
region_code |
VARCHAR | Abbreviated code for the state or region. | No | |
region_name |
VARCHAR | Full name of the state or region. | No | |
country_id |
INTEGER | Unique identifier for a country. | No | |
country_code |
VARCHAR | Abbreviated code for the country. | Yes | |
country_name |
VARCHAR | Full name of the country. | No | |
iso3166_alpha_code |
VARCHAR | ISO 3166 alpha code for the country. | Yes |