
--Migration_RCCP_20250424_094823.txt
CREATE TABLE [dbo].[RuleConditions] (
    [Id] [bigint] NOT NULL IDENTITY,
    [ConditionType] [int] NOT NULL,
    [Metrics] [nvarchar](max),
    [TimeToTrigger] [int] NOT NULL,
    [FromStates] [nvarchar](max),
    [ToState] [nvarchar](max),
    CONSTRAINT [PK_dbo.RuleConditions] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[ThresholdMonitors] (
    [Id] [bigint] NOT NULL IDENTITY,
    [EntityType] [nvarchar](max),
    [EntityId] [nvarchar](max),
    [RuleId] [bigint] NOT NULL,
    [CurrentStatus] [nvarchar](max),
    [StatusLastUpdatedUtcDateTime] [datetime] NOT NULL,
    [LastAlertSentUtcDateTime] [datetime] NOT NULL,
    [SupressionUntilUtcDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.ThresholdMonitors] PRIMARY KEY ([Id])
)
