
--Migration_RCCP_20251215_103137.txt
CREATE TABLE [dbo].[DataCollectionSchedules] (
    [Id] [bigint] NOT NULL IDENTITY,
    [FloorplanId] [bigint] NOT NULL,
    [DevicePairId] [bigint] NOT NULL,
    [Type] [nvarchar](max),
    [StartDateTime] [datetime] NOT NULL,
    [Duration] [int] NOT NULL,
    [interval] [int] NOT NULL,
    [UserId] [bigint],
    [CreatedUTCDateTime] [datetime] NOT NULL,
    [LastUpdatedUTCDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.DataCollectionSchedules] PRIMARY KEY ([Id])
)
