
--Migration_RCCP_20241113_125150.txt
CREATE TABLE [dbo].[BranchCatchmentCompetitors] (
    [CompetitorId] [bigint] NOT NULL IDENTITY,
    [BranchId] [bigint] NOT NULL,
    [CompetitorName] [varchar](255),
    [BusinessType] [varchar](255),
    [Address] [nvarchar](max),
    [DistanceM] [float] NOT NULL,
    [Latitude] [float] NOT NULL,
    [Longitude] [float] NOT NULL,
    [OperatingHour] [nvarchar](max),
    CONSTRAINT [PK_dbo.BranchCatchmentCompetitors] PRIMARY KEY ([CompetitorId])
)
CREATE TABLE [dbo].[BranchCatchmentDatas] (
    [Id] [bigint] NOT NULL IDENTITY,
    [BranchId] [bigint] NOT NULL,
    [BusinessType] [varchar](255),
    [Address] [nvarchar](max),
    [OperatingHour] [varchar](255),
    [AveragePropertyPrice] [float] NOT NULL,
    [Area] [float] NOT NULL,
    [LiveableArea] [float] NOT NULL,
    [StoreLocatedArea] [varchar](255),
    [TotalPopulation] [bigint] NOT NULL,
    [TargetPopulation] [bigint] NOT NULL,
    [WomenPopulation] [bigint] NOT NULL,
    [MenPopulation] [bigint] NOT NULL,
    [ChildrenUnder_5_Population] [bigint] NOT NULL,
    [Children_6_14_Population] [bigint] NOT NULL,
    [Youth_15_24_Population] [bigint] NOT NULL,
    [Adult_25_59_Population] [bigint] NOT NULL,
    [ElderlyAbove_60_Population] [bigint] NOT NULL,
    [Women_15_49_Population] [bigint] NOT NULL,
    [IsoChrone] [nvarchar](max),
    CONSTRAINT [PK_dbo.BranchCatchmentDatas] PRIMARY KEY ([Id])
)
