
--Migration_RCCP_20220830_181539.txt
CREATE TABLE [dbo].[AreaUsageSessionsSummaries] (
    [MeetingId] [bigint] NOT NULL IDENTITY,
    [AreaId] [bigint] NOT NULL,
    [SessionId] [bigint],
    [BookingId] [bigint],
    [MeetingStartDateTime] [datetime],
    [MeetingEndDateTime] [datetime],
    [MeetingDuration] [int] NOT NULL,
    [MeetingStatus] [nvarchar](max),
    [MeetingAvgOccupancy] [float] NOT NULL,
    CONSTRAINT [PK_dbo.AreaUsageSessionsSummaries] PRIMARY KEY ([MeetingId])
)
CREATE TABLE [dbo].[MetricTables] (
    [ID] [int] NOT NULL IDENTITY,
    [MetricCode] [nvarchar](max),
    [MetricName] [nvarchar](max),
    [ReferenceKey] [nvarchar](max),
    [MetricDescription] [nvarchar](max),
    [HeroicGuideLink] [nvarchar](max),
    [MetricOutputFormat] [nvarchar](max),
    CONSTRAINT [PK_dbo.MetricTables] PRIMARY KEY ([ID])
)
