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