
--Migration_RCCP_20241008_101704.txt
CREATE TABLE [dbo].[SiteFootfallConfigurations] (
    [Id] [bigint] NOT NULL IDENTITY,
    [BranchId] [bigint] NOT NULL,
    [CreateDateTime] [datetime] NOT NULL,
    [MetricCode] [nvarchar](max),
    [DayOfWeek] [int] NOT NULL,
    [Time] [datetime] NOT NULL,
    [Value] [float] NOT NULL,
    [ValueType] [nvarchar](max),
    CONSTRAINT [PK_dbo.SiteFootfallConfigurations] PRIMARY KEY ([Id])
)
