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 |