---
schema_version: "1"
id: 2f8d31f319977db24a93bece2dcaf34cdfbc6c33a97f46dcc51eb30b0ed7049b
title: ccdw_dim_geography
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/commerce-cloud/b2c-commerce/guides/jdbc/jdbc_ccdw_dim_geography.md
canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_geography.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: cd908cb4f56a3d0aaadf57bda31e888a915bdc2b3a40b9be34fb9a664134d581
products:
  - Composable Storefront
  - Salesforce APIs
---
# 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    |

<!-- **Indices**: `geography_id`, `iso3166_alpha_code`, `country_code` -->