ccdw_dim_geography
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 |