
[dbo].[al_link_role_config]
CREATE TABLE [dbo].[al_link_role_config]
(
[config_id] [int] NOT NULL,
[role_id] [int] NOT NULL,
[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_LINK_R__VERSI__30592A6F] DEFAULT ('0')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_link_role_config] ADD CONSTRAINT [al_link_role_config_pk] PRIMARY KEY CLUSTERED ([config_id], [role_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_link_role_config] ADD CONSTRAINT [AL_LINK_ROLE_CONFIG_AL_CO_FK1] FOREIGN KEY ([config_id]) REFERENCES [dbo].[al_configuration_def] ([id])
GO
ALTER TABLE [dbo].[al_link_role_config] ADD CONSTRAINT [AL_LINK_ROLE_CONFIG_AL_RO_FK1] FOREIGN KEY ([role_id]) REFERENCES [dbo].[al_role_def] ([role_id])
GO