
[dbo].[HYBRID_ROLE_PERMISSIONS]
CREATE TABLE [dbo].[HYBRID_ROLE_PERMISSIONS]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[PERMISSION_ID] [int] NOT NULL,
[ROLE_ID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IS_ALLOWED] [smallint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HYBRID_ROLE_PERMISSIONS] ADD CONSTRAINT [PK__HYBRID_ROLE_PERM__21B6055D] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HYBRID_ROLE_PERMISSIONS] ADD CONSTRAINT [UQ__HYBRID_ROLE_PERM__22AA2996] UNIQUE NONCLUSTERED ([PERMISSION_ID], [ROLE_ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HYBRID_ROLE_PERMISSIONS] ADD CONSTRAINT [FK__HYBRID_RO__PERMI__239E4DCF] FOREIGN KEY ([PERMISSION_ID]) REFERENCES [dbo].[HYBRID_PERMISSIONS] ([ID]) ON DELETE CASCADE
GO