
--Migration_RCCP_20240308_091955.txt
CREATE TABLE [dbo].[Policies] (
    [Id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [Name] [nvarchar](max),
    [EntityType] [nvarchar](max),
    [DefaultValue] [bit] NOT NULL,
    CONSTRAINT [PK_dbo.Policies] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[PolicyApplications] (
    [Id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [PolicyId] [uniqueidentifier] NOT NULL,
    [EntityType] [nvarchar](max),
    [EntityId] [nvarchar](max),
    [CompanyId] [bigint] NOT NULL,
    [Value] [bit] NOT NULL,
    [AllowOverride] [bit] NOT NULL,
    [CreatedUtcDateTime] [datetime] NOT NULL,
    [UpdatedUtcDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.PolicyApplications] PRIMARY KEY ([Id])
)
