Dipanshu Kumar
46 lines
2.8 KiB
Transact-SQL
46 lines
2.8 KiB
Transact-SQL
USE [CPMIndiaBusinessInsight]
|
|
GO
|
|
/****** Object: Table [dbo].[SKU Master] Script Date: 5/18/2026 5:34:09 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[SKU Master](
|
|
[pk] [int] IDENTITY(1,1) NOT NULL,
|
|
[project_id] [int] NOT NULL,
|
|
[category_id] [int] NULL,
|
|
[category_code] [varchar](255) NULL,
|
|
[Category_name] [varchar](255) NULL,
|
|
[sub_category_id] [int] NULL,
|
|
[sub_category_code] [varchar](255) NULL,
|
|
[sub_category_name] [varchar](255) NULL,
|
|
[brand_id] [int] NULL,
|
|
[brand_code] [varchar](255) NULL,
|
|
[brand_name] [varchar](255) NULL,
|
|
[sub_brand_id] [int] NULL,
|
|
[sub_brand_code] [varchar](255) NULL,
|
|
[sub_brand_name] [varchar](255) NULL,
|
|
[product_id] [int] NULL,
|
|
[product_name] [varchar](255) NULL,
|
|
[product_code] [varchar](255) NULL,
|
|
[parent_product_id] [varchar](255) NULL,
|
|
[parent_product_name] [varchar](255) NULL,
|
|
[pack_id] [varchar](255) NULL,
|
|
[pack_name] [varchar](255) NULL,
|
|
[division_id] [varchar](255) NULL,
|
|
[division_name] [varchar](255) NULL,
|
|
[mrp] [float] NULL,
|
|
[flavour_id] [int] NULL,
|
|
[flavour] [varchar](255) NULL,
|
|
[grammage] [varchar](255) NULL,
|
|
[product_sequence] [int] NULL,
|
|
[case_size] [float] NULL,
|
|
[product_wgt_type] [varchar](255) NULL,
|
|
[company_name] [varchar](100) NULL,
|
|
[is_competitor] [bit] NULL,
|
|
[ptr] [numeric](10, 2) NULL,
|
|
[update_date] [date] NULL,
|
|
[update_by] [varchar](100) NULL
|
|
) ON [PRIMARY]
|
|
GO
|