
--Migration_RCCP_20220905_170915.txt
CREATE TABLE [dbo].[SiteTargetPlanningWorkspaces] (
    [ID] [bigint] NOT NULL IDENTITY,
    [Name] [nvarchar](max),
    [CompanyTargetPlanningId] [bigint] NOT NULL,
    [Changes] [float] 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.SiteTargetPlanningWorkspaces] PRIMARY KEY ([ID])
)
