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