
--Migration_RCCP_20220726_165421.txt
CREATE TABLE [dbo].[TargetPlanningWorkspaces] (
    [ID] [bigint] NOT NULL IDENTITY,
    [Name] [nvarchar](max),
    [StartCampaignPeriod] [datetime] NOT NULL,
    [EndCampaignPeriod] [datetime] NOT NULL,
    [StartBenchmarkPeriod] [datetime] NOT NULL,
    [EndBenchmarkPeriod] [datetime] NOT NULL,
    [CreatedDateTime] [datetime] NOT NULL,
    [CreatedBy] [bigint] NOT NULL,
    [SalesVolume] [float] NOT NULL,
    [SalesConversion] [float] NOT NULL,
    [NoOfUnitsPerTransaction] [float] NOT NULL,
    [Footfall] [int] NOT NULL,
    [NoOfTransactions] [int] NOT NULL,
    [NoOfUnitsSold] [int] NOT NULL,
    [AverageSalesVolumePerFootfall] [float] NOT NULL,
    [AverageSalesVolumePerTransaction] [float] NOT NULL,
    [AveragePricePerUnit] [float] NOT NULL,
    CONSTRAINT [PK_dbo.TargetPlanningWorkspaces] PRIMARY KEY ([ID])
)
