
--Migration_RCCP_20220705_121743.txt
CREATE TABLE [dbo].[AreaStaffHours] (
    [ID] [bigint] NOT NULL IDENTITY,
    [AreaId] [bigint] NOT NULL,
    [ValueDateTime] [datetime] NOT NULL,
    [StaffCount] [bigint] NOT NULL,
    [RowCreatedDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.AreaStaffHours] PRIMARY KEY ([ID])
)
CREATE TABLE [dbo].[AreaTransactionDatas] (
    [ID] [bigint] NOT NULL IDENTITY,
    [AreaId] [bigint] NOT NULL,
    [ValueDateTime] [datetime] NOT NULL,
    [TransactionCount] [bigint] NOT NULL,
    [UnitSold] [bigint] NOT NULL,
    [SalesAmount] [float] NOT NULL,
    [AverageAmount] [float] NOT NULL,
    [RowCreatedDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.AreaTransactionDatas] PRIMARY KEY ([ID])
)
