
--Migration_RCCP_20251117_123701.txt
CREATE TABLE [dbo].[CalibrationGroundTruths] (
    [ID] [bigint] NOT NULL IDENTITY,
    [CompanyId] [bigint] NOT NULL,
    [BranchId] [bigint] NOT NULL,
    [Timestamp] [bigint] NOT NULL,
    [GroundTruth] [int] NOT NULL,
    [CreateDateTime] [datetime] NOT NULL,
    [UpdatedDateTime] [datetime],
    CONSTRAINT [PK_dbo.CalibrationGroundTruths] PRIMARY KEY ([ID])
)
CREATE TABLE [dbo].[OutsideTrafficCalibrations] (
    [ID] [bigint] NOT NULL IDENTITY,
    [Type] [nvarchar](max),
    [MAC] [nvarchar](max),
    [RSSI] [int] NOT NULL,
    [Timestamp] [bigint] NOT NULL,
    [DeviceSerial] [nvarchar](max),
    [CompanyId] [bigint] NOT NULL,
    [BranchId] [bigint] NOT NULL,
    [Value] [int] NOT NULL,
    CONSTRAINT [PK_dbo.OutsideTrafficCalibrations] PRIMARY KEY ([ID])
)
