
--Migration_RCCP_20220823_141807.txt
CREATE TABLE [dbo].[SiteDiscrepancySummaries] (
    [Id] [bigint] NOT NULL IDENTITY,
    [AreaId] [bigint] NOT NULL,
    [DayNumber] [int] NOT NULL,
    [DiscrepancyPercentage] [real] NOT NULL,
    [IsBreached] [bit] NOT NULL,
    CONSTRAINT [PK_dbo.SiteDiscrepancySummaries] PRIMARY KEY ([Id])
)
