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