Tables [dbo].[HYBRID_ROLE_PERMISSIONS]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created1:08:00 AM Thursday, September 10, 2009
Last Modified1:08:00 AM Thursday, September 10, 2009
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK__HYBRID_ROLE_PERM__21B6055D: IDIDint4
No
1 - 1
Foreign Keys FK__HYBRID_RO__PERMI__239E4DCF: [dbo].[HYBRID_PERMISSIONS].PERMISSION_IDIndexes UQ__HYBRID_ROLE_PERM__22AA2996: PERMISSION_ID\ROLE_IDPERMISSION_IDint4
No
Indexes UQ__HYBRID_ROLE_PERM__22AA2996: PERMISSION_ID\ROLE_IDROLE_IDvarchar(255)255
No
IS_ALLOWEDsmallint2
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__HYBRID_ROLE_PERM__21B6055D: IDPK__HYBRID_ROLE_PERM__21B6055DID
Yes
UQ__HYBRID_ROLE_PERM__22AA2996PERMISSION_ID, ROLE_ID
Yes
Foreign Keys Foreign Keys
NameDeleteColumns
FK__HYBRID_RO__PERMI__239E4DCFCascadePERMISSION_ID->[dbo].[HYBRID_PERMISSIONS].[ID]
SQL Script
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
Uses