# ccdw_dim_product

This table contains detailed information about products and SKUs. Each SKU rolls up to a product.

| Column Alias               | Data Type | Key    | Description                                                                          | Index? |
| -------------------------- | --------- | ------ | ------------------------------------------------------------------------------------ | ------ |
| `sku_id (PK)`              | INTEGER   | **PK** | Unique identifier for a Stock Keeping Unit (SKU).                                    | Yes    |
| `nsku_id`                  | VARCHAR   |        | Natural key of the SKU, representing the ID of the SKU in the source system.         | Yes    |
| `sku_display_name`         | VARCHAR   |        | User-friendly display name for the SKU.                                              | No     |
| `sku_upc_code`             | VARCHAR   |        | UPC (Universal Product Code) for the SKU.                                            | No     |
| `sku_ean_code`             | VARCHAR   |        | EAN (European Article Number) for the SKU.                                           | No     |
| `sku_brand`                | VARCHAR   |        | Brand name of the SKU.                                                               | No     |
| `sku_manufacture_name`     | VARCHAR   |        | Manufacturer's name for the SKU.                                                     | No     |
| `sku_manufacture_sku`      | VARCHAR   |        | Manufacturer's SKU for the product.                                                  | No     |
| `product_id`               | INTEGER   |        | Unique identifier for a product.                                                     | Yes    |
| `nproduct_id`              | VARCHAR   |        | Natural key of the product, representing the ID of the product in the source system. | Yes    |
| `product_display_name`     | VARCHAR   |        | User-friendly display name for the product.                                          | No     |
| `product_upc_code`         | VARCHAR   |        | UPC for the product.                                                                 | No     |
| `product_ean_code`         | VARCHAR   |        | EAN for the product.                                                                 | No     |
| `product_brand`            | VARCHAR   |        | Brand name of the product.                                                           | No     |
| `product_manufacture_name` | VARCHAR   |        | Manufacturer's name for the product.                                                 | No     |
| `product_manufacture_sku`  | VARCHAR   |        | Manufacturer's SKU for the product.                                                  | No     |
| `is_master`                | BOOLEAN   |        | Boolean indicating if it's a master product.                                         | No     |
| `is_bundle`                | BOOLEAN   |        | Boolean indicating if it's a product bundle.                                         | No     |