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__48CFD27E] DEFAULT ('0'),
[core] [smallint] NULL CONSTRAINT [DF__al_role_de__core__49C3F6B7] 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__4AB81AF0] 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__4BAC3F29] DEFAULT ('0'),
[role_access] [smallint] NULL CONSTRAINT [DF__al_role_d__role___4CA06362] DEFAULT ('0'),
[user_access] [smallint] NULL CONSTRAINT [DF__al_role_d__user___4D94879B] DEFAULT ('0'),
[system_config_access] [smallint] NULL CONSTRAINT [DF__al_role_d__syste__4E88ABD4] DEFAULT ('0'),
[reconciliation_access] [smallint] NULL CONSTRAINT [DF__al_role_d__recon__4F7CD00D] DEFAULT ('0'),
[asset_fulfillment_access] [smallint] NULL,
[tenancy_admin_access] [int] NULL,
[api_access] [smallint] NULL CONSTRAINT [DF__AL_ROLE_DEF_API_ACCESS] DEFAULT ('0')
) 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