CREATE TABLE [dbo].[al_role_def]
(
[role_id] [int] NOT NULL,
[role_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[inactive] [int] NULL CONSTRAINT [DF__al_role_d__inact__0FB9E482] DEFAULT ('0'),
[core] [smallint] NULL CONSTRAINT [DF__al_role_de__core__10AE08BB] DEFAULT ('0'),
[tenant_access_read] [int] NULL,
[single_tenant_read] [binary] (16) NULL,
[tenant_group_read] [binary] (16) NULL,
[tenant_access_write] [int] NULL,
[single_tenant_write] [binary] (16) NULL,
[tenant_group_write] [binary] (16) NULL,
[update_public] [smallint] NULL CONSTRAINT [DF__al_role_d__updat__11A22CF4] DEFAULT ('0'),
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__al_role_d__versi__1296512D] DEFAULT ('0'),
[role_access] [smallint] NULL CONSTRAINT [DF__al_role_d__role___138A7566] DEFAULT ('0'),
[user_access] [smallint] NULL CONSTRAINT [DF__al_role_d__user___147E999F] DEFAULT ('0'),
[system_config_access] [smallint] NULL CONSTRAINT [DF__al_role_d__syste__1572BDD8] DEFAULT ('0'),
[reconciliation_access] [smallint] NULL CONSTRAINT [DF__al_role_d__recon__1666E211] DEFAULT ('0'),
[asset_fulfillment_access] [smallint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_role_def] ADD CONSTRAINT [pk_al_role_def] PRIMARY KEY CLUSTERED ([role_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_role_def] ADD CONSTRAINT [al_role_def_fk01] FOREIGN KEY ([tenant_access_read]) REFERENCES [dbo].[al_tenant_access_types] ([id])
GO
ALTER TABLE [dbo].[al_role_def] ADD CONSTRAINT [al_role_def_fk02] FOREIGN KEY ([single_tenant_read]) REFERENCES [dbo].[ca_tenant] ([id])
GO
ALTER TABLE [dbo].[al_role_def] ADD CONSTRAINT [al_role_def_fk03] FOREIGN KEY ([tenant_group_read]) REFERENCES [dbo].[ca_tenant_group] ([id])
GO
ALTER TABLE [dbo].[al_role_def] ADD CONSTRAINT [al_role_def_fk04] FOREIGN KEY ([tenant_access_write]) REFERENCES [dbo].[al_tenant_access_types] ([id])
GO
ALTER TABLE [dbo].[al_role_def] ADD CONSTRAINT [al_role_def_fk05] FOREIGN KEY ([single_tenant_write]) REFERENCES [dbo].[ca_tenant] ([id])
GO
ALTER TABLE [dbo].[al_role_def] ADD CONSTRAINT [al_role_def_fk06] FOREIGN KEY ([tenant_group_write]) REFERENCES [dbo].[ca_tenant_group] ([id])
GO