
--Migration_RCCP_20250918_085519.txt
CREATE TABLE [dbo].[AlertJobInstances] (
    [Id] [bigint] NOT NULL IDENTITY,
    [JobType] [nvarchar](max),
    [EntityType] [nvarchar](max),
    [EntityId] [nvarchar](max),
    [SubEntityType] [nvarchar](max),
    [SubEntityTypeId] [nvarchar](max),
    [AlertType] [nvarchar](max),
    [Status] [nvarchar](max),
    [RetryCount] [int] NOT NULL,
    [CreatedUtcDateTime] [datetime],
    [LastAttemptDateTime] [datetime],
    [Recipients] [nvarchar](max),
    [Subject] [nvarchar](max),
    [TemplateName] [nvarchar](max),
    [MessageBody] [nvarchar](max),
    [MediaUrl] [nvarchar](max),
    [IntegrationConnectorId] [bigint],
    CONSTRAINT [PK_dbo.AlertJobInstances] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[SessionMetricLinks] (
    [Id] [bigint] NOT NULL IDENTITY,
    [SessionId] [bigint] NOT NULL,
    [Metric] [nvarchar](max),
    CONSTRAINT [PK_dbo.SessionMetricLinks] PRIMARY KEY ([Id])
)
