Dipanshu Kumar
40 lines
2.7 KiB
Transact-SQL
40 lines
2.7 KiB
Transact-SQL
USE [CPMIndiaBusinessInsight]
|
|
GO
|
|
/****** Object: Table [dbo].[PaidVisibility_Compliance] Script Date: 5/18/2026 5:34:09 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[PaidVisibility_Compliance](
|
|
[pk] [bigint] IDENTITY(1,1) NOT NULL,
|
|
[project_id] [int] NOT NULL,
|
|
[store_id] [int] NOT NULL,
|
|
[employee_id] [int] NOT NULL,
|
|
[visit_date] [date] NOT NULL,
|
|
[supervisor_id] [int] NOT NULL,
|
|
[channel_id] [int] NOT NULL,
|
|
[chain_id] [int] NOT NULL,
|
|
[storetype_id] [int] NOT NULL,
|
|
[visibility_id] [int] NULL,
|
|
[visibility_name] [nvarchar](200) NULL,
|
|
[visibility_definition_id] [int] NULL,
|
|
[visibility_definition_name] [nvarchar](200) NULL,
|
|
[question_id] [int] NULL,
|
|
[question] [nvarchar](150) NULL,
|
|
[question_answer] [nvarchar](150) NULL,
|
|
[score] [int] NULL,
|
|
[image1] [nvarchar](500) NULL,
|
|
[image2] [nvarchar](500) NULL,
|
|
[auditor_name] [nvarchar](150) NULL,
|
|
[audit_date] [date] NULL,
|
|
[audit_time] [time](7) NULL,
|
|
[update_date] [date] NOT NULL,
|
|
[update_by] [varchar](50) NOT NULL,
|
|
[PaidVisibilityDetailsId] [int] NULL,
|
|
[PaidVisibilityDetails] [nvarchar](100) NULL,
|
|
[Paid_VisiValueName] [nvarchar](100) NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
ALTER TABLE [dbo].[PaidVisibility_Compliance] ADD CONSTRAINT [DF_PaidVisibility_Compliance_update_date] DEFAULT (getdate()) FOR [update_date]
|
|
GO
|