Dipanshu Kumar
47 lines
3.1 KiB
Transact-SQL
47 lines
3.1 KiB
Transact-SQL
USE [CPMIndiaBusinessInsight]
|
|
GO
|
|
/****** Object: Table [dbo].[Store_Master] Script Date: 5/18/2026 5:34:09 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[Store_Master](
|
|
[project_id] [bigint] NOT NULL,
|
|
[project_name] [nvarchar](max) NULL,
|
|
[region_id] [bigint] NOT NULL,
|
|
[region] [nvarchar](max) NOT NULL,
|
|
[state_id] [bigint] NOT NULL,
|
|
[state] [nvarchar](max) NOT NULL,
|
|
[city_id] [bigint] NULL,
|
|
[city] [nvarchar](max) NULL,
|
|
[cpm_city_id] [nvarchar](max) NULL,
|
|
[channel_id] [bigint] NULL,
|
|
[channel] [nvarchar](max) NULL,
|
|
[distributor_id] [bigint] NULL,
|
|
[distributor_name] [nvarchar](max) NULL,
|
|
[keyaccount_id] [bigint] NULL,
|
|
[keyaccount] [nvarchar](max) NULL,
|
|
[insight_store_id] [nvarchar](max) NULL,
|
|
[client_store_code] [nvarchar](max) NULL,
|
|
[asm_area_id] [nvarchar](max) NULL,
|
|
[asm_area_name] [nvarchar](max) NULL,
|
|
[so_bde_area_id] [nvarchar](max) NULL,
|
|
[so_bde_area] [nvarchar](max) NULL,
|
|
[longitude] [float] NULL,
|
|
[latitude] [float] NULL,
|
|
[store_category_id] [bigint] NULL,
|
|
[store_category] [nvarchar](max) NULL,
|
|
[store_type_id] [bigint] NULL,
|
|
[store_type] [nvarchar](max) NULL,
|
|
[store_classification_id] [bigint] NULL,
|
|
[store_classification] [nvarchar](max) NULL,
|
|
[StLayerFourId] [int] NULL,
|
|
[store_id] [bigint] NOT NULL,
|
|
[store_name] [nvarchar](max) NOT NULL,
|
|
[address] [nvarchar](max) NULL,
|
|
[pin_code] [nvarchar](max) NULL,
|
|
[is_pharmacy_store] [nvarchar](max) NULL,
|
|
[Unique_Store_ID] [varchar](30) NULL
|
|
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
|
|
GO
|