
--Migration_RCCP_20251212_132906.txt
CREATE TABLE [dbo].[DevicePairCollections] (
    [Id] [bigint] NOT NULL IDENTITY,
    [FloorplanId] [bigint] NOT NULL,
    [DeviceASerial] [nvarchar](max),
    [DeviceAChannel] [nvarchar](max),
    [DeviceBSerial] [nvarchar](max),
    [DeviceBChannel] [nvarchar](max),
    [MappingAtoB] [nvarchar](max),
    [MappingBtoA] [nvarchar](max),
    [CreatedUTCDateTime] [datetime] NOT NULL,
    [LastUpdatedUTCDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.DevicePairCollections] PRIMARY KEY ([Id])
)
