# Dimension Tables

Dimension tables store descriptive attributes that provide context to the facts.

| Dimension Table Name                                                                               | Description                                                                                                                                                                              | Indices                                                                                                                                                                                                                              |
| -------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| [ccdw_dim_business_channel](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_business_channel.md)   | Categorizes different business channels.                                                                                                                                                 | `business_channel_id`, `business_type,order_channel`                                                                                                                                                                                 |
| [ccdw_dim_campaign](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_campaign.md)                   | Describes various marketing campaigns.                                                                                                                                                   | `campaign_id`, `ncampaign_id`                                                                                                                                                                                                        |
| [ccdw_dim_coupon](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_coupon.md)                       | Provides details about coupons.                                                                                                                                                          | `coupon_id`, `ncoupon_id`                                                                                                                                                                                                            |
| [ccdw_dim_currency](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_currency.md)                   | Provides details about various currencies. Each row represents an ISO 4217 currency.                                                                                                     | `currency_id`, `alpha_code`                                                                                                                                                                                                          |
| [ccdw_dim_customer](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_customer.md)                   | Contains detailed information about customers.                                                                                                                                           | `customer_id`, `ncustomer_id`                                                                                                                                                                                                        |
| [ccdw_dim_date](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_date.md)                           | Contains various attributes related to dates, providing detailed temporal information. Each record represents a calendar date and its component parts (year, quarter, month, week, day). | `day_id`, `day_timestamp`, `week_id`, `week_timestamp`, `month_id`, `month_timestamp`, `quarter_id`, `quarter_timestamp`, `year_id`, `year_timestamp`, `weekyear_id`, `weekyear_timestamp`, `year_of_era,month_of_year,day_of_month` |
| [ccdw_dim_geography](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_geography.md)                 | Provides geographical information, particularly for regions and countries. Each region rolls up to a country.                                                                            | `geography_id`, `iso3166_alpha_code`, `country_code`                                                                                                                                                                                 |
| [ccdw_dim_locale](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_locale.md)                       | Stores information about different locales, such as language and country settings.                                                                                                       | `locale_id`, `locale_code`                                                                                                                                                                                                           |
| [ccdw_dim_location](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_location.md)                   | Represents individual physical locations, likely for inventory or shipping.                                                                                                              | `location_id`, `nlocation_id`                                                                                                                                                                                                        |
| [ccdw_dim_location_group](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_location_group.md)       | Groups physical locations together.                                                                                                                                                      | `location_group_id`, `nlocation_group_id`                                                                                                                                                                                            |
| [ccdw_dim_payment_method](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_payment_method.md)       | Lists available payment methods.                                                                                                                                                         | `payment_method_id`, `npayment_method_id`                                                                                                                                                                                            |
| [ccdw_dim_product](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_product.md)                     | Contains detailed information about products and SKUs. Each SKU rolls up to a product.                                                                                                   | `sku_id`, `nsku_id`, `product_id`, `nproduct_id`                                                                                                                                                                                     |
| [ccdw_dim_promotion](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_promotion.md)                 | Describes various promotions.                                                                                                                                                            | `promotion_id`, `npromotion_id`                                                                                                                                                                                                      |
| [ccdw_dim_site](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_site.md)                           | Stores information about different e-commerce sites or storefronts.                                                                                                                      | `site_id`, `nsite_id,nrealm_id`                                                                                                                                                                                                      |
| [ccdw_dim_source_code_group](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_source_code_group.md) | Categorizes source code groups, often used for tracking marketing channels.                                                                                                              | `source_code_group_id`, `nsource_code_group_id`                                                                                                                                                                                      |
| [ccdw_dim_time](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_time.md)                           | Contains various attributes related to time, providing detailed temporal information within a day. Each row represents a minute of a clock.                                              | `time_id`, `minute_of_day`, `hour_of_day`                                                                                                                                                                                            |
| [ccdw_dim_timezone](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_timezone.md)                   | Contains information about different time zones.                                                                                                                                         | `timezone_id`, `ntimezone_id`                                                                                                                                                                                                        |
| [ccdw_dim_traffic_source](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_traffic_source.md)       | Describes attributed external traffic sources.                                                                                                                                           | `traffic_source_id`                                                                                                                                                                                                                  |
| [ccdw_dim_user_agent](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md)               | Stores details about user agents, which describe the client software making a request.                                                                                                   | `user_agent_id`, `nuser_agent_id`, `ua_family_code`, `ua_class_code`, `ua_family_vendor_code`, `crawler_category_code`, `os_family_code`, `os_family_vendor_code`, `device_class_code`, `device_brand_code`                          |