
--Migration_RCCP_20220919_165836.txt
CREATE TABLE [dbo].[PredictiveAnalyzationValues] (
    [Id] [bigint] NOT NULL IDENTITY,
    [AreaId] [bigint] NOT NULL,
    [BranchId] [bigint] NOT NULL,
    [CompanyId] [bigint] NOT NULL,
    [CreatedDateTime] [datetime],
    [TimeGranularity] [nvarchar](max),
    [MetricCode] [nvarchar](max),
    [PredictionDateTime] [datetime],
    [Prediction] [float] NOT NULL,
    [PredictionLower] [float] NOT NULL,
    [PredictionUpper] [float] NOT NULL,
    [ConfidenceLevel] [int] NOT NULL,
    CONSTRAINT [PK_dbo.PredictiveAnalyzationValues] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[QueuePredictions] (
    [Id] [bigint] NOT NULL IDENTITY,
    [AreaId] [bigint] NOT NULL,
    [BranchId] [bigint] NOT NULL,
    [CompanyId] [bigint] NOT NULL,
    [CreatedDateTime] [datetime] NOT NULL,
    [PredictionDateTime] [datetime],
    [ArrivalRate] [float],
    [ServiceRate] [float],
    [NumberOfCashiers] [int],
    [SalesConversion] [float],
    [ShoppingDuration] [float],
    [PredictionMethod] [nvarchar](max),
    [PredictionQueueTime] [float],
    [PredictionQueueLength] [float],
    [PredictionQueueAndServeTime] [float],
    CONSTRAINT [PK_dbo.QueuePredictions] PRIMARY KEY ([Id])
)
