CREATE TABLE [dbo].[DimProductCategory](
    [product_category_id] [INT] IDENTITY(1,1) NOT NULL,
    [name] [VARCHAR](50) NULL,
 CONSTRAINT [PK_DimProductCategory] PRIMARY KEY CLUSTERED
(
    [product_category_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


CREATE TABLE [dbo].[DimProductContainer](
    [product_container_id] [INT] IDENTITY(1,1) NOT NULL,
    [name] [VARCHAR](50) NULL,
 CONSTRAINT [PK_DimProductContainer] PRIMARY KEY CLUSTERED
(
    [product_container_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


CREATE TABLE [dbo].[DimProductSubCategory](
    [product_subcategory_id] [INT] IDENTITY(1,1) NOT NULL,
    [name] [VARCHAR](50) NULL,
 CONSTRAINT [PK_DimProductSubCategory] PRIMARY KEY CLUSTERED
(
    [product_subcategory_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


CREATE TABLE [dbo].[DimProduct](
    [product_id] [INT] IDENTITY(1,1) NOT NULL,
    [name] [VARCHAR](100) NULL,
    [unit_price] [FLOAT] NULL,
    [base_margin] [FLOAT] NULL,
    [product_category_id] [INT] NULL,
    [product_subcategory_id] [INT] NULL,
    [product_container_id] [INT] NULL,
 CONSTRAINT [PK_DimProduct] PRIMARY KEY CLUSTERED
(
    [product_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]