
--Migration_RCCP_20250620_091648.txt
CREATE TABLE [dbo].[OccupancyAccuracyAudits] (
    [Id] [bigint] NOT NULL IDENTITY,
    [BranchId] [bigint] NOT NULL,
    [CompanyId] [bigint] NOT NULL,
    [FloorPlanId] [bigint] NOT NULL,
    [FileName] [nvarchar](max),
    [FloorPlanLiveViewStitchImage] [nvarchar](max),
    [ThreeDimensionFloorPlanWithBlob] [nvarchar](max),
    [Comment] [nvarchar](max),
    [Details] [nvarchar](max),
    [SystemCount] [int] NOT NULL,
    [ManualCount] [int] NOT NULL,
    [CreatedDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.OccupancyAccuracyAudits] PRIMARY KEY ([Id])
)
