
--Migration_RCCP_20250604_085548.txt
CREATE TABLE [dbo].[Sessions] (
    [Id] [bigint] NOT NULL IDENTITY,
    [Mode] [nvarchar](max),
    [Name] [nvarchar](max),
    [BranchId] [bigint] NOT NULL,
    [StartDateTime] [datetime] NOT NULL,
    [EndDateTime] [datetime] NOT NULL,
    [RecurringDetail] [nvarchar](max),
    CONSTRAINT [PK_dbo.Sessions] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[SessionInstances] (
    [Id] [bigint] NOT NULL IDENTITY,
    [SessionId] [bigint] NOT NULL,
    [StartDateTime] [datetime] NOT NULL,
    [EndDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.SessionInstances] PRIMARY KEY ([Id])
)
