[dbo].[UM_ROLE_PERMISSIONS]

Property	Value
Row Count	3398
Created	1:08:00 AM Thursday, September 10, 2009
Last Modified	1:08:00 AM Thursday, September 10, 2009

Property

Value

Row Count

3398

Created

1:08:00 AM Thursday, September 10, 2009

Last Modified

1:08:00 AM Thursday, September 10, 2009

	Name	Data Type	Max Length (Bytes)	Identity
	ID	int	4	1 - 1
$Indexes UQ__UM_ROLE_PERMISSI__0DAF0CB0: PERMISSION_ID\ROLE_ID$	PERMISSION_ID	int	4
$Indexes UQ__UM_ROLE_PERMISSI__0DAF0CB0: PERMISSION_ID\ROLE_ID$	ROLE_ID	int	4
	IS_ALLOWED	smallint	2

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

Cluster Primary Key PK__UM_ROLE_PERMISSI__0CBAE877: ID

int

1 - 1

$Indexes UQ__UM_ROLE_PERMISSI__0DAF0CB0: PERMISSION_ID\ROLE_ID$

PERMISSION_ID

int

$Indexes UQ__UM_ROLE_PERMISSI__0DAF0CB0: PERMISSION_ID\ROLE_ID$

ROLE_ID

int

IS_ALLOWED

smallint

	Name	Columns	Unique
	PK__UM_ROLE_PERMISSI__0CBAE877	ID
	UQ__UM_ROLE_PERMISSI__0DAF0CB0	PERMISSION_ID, ROLE_ID

Name

Columns

Unique

PK__UM_ROLE_PERMISSI__0CBAE877

UQ__UM_ROLE_PERMISSI__0DAF0CB0

PERMISSION_ID, ROLE_ID

Name	Delete	Columns
FK__UM_ROLE_P__PERMI__0EA330E9	Cascade	PERMISSION_ID->[dbo].[UM_PERMISSIONS].[ID]
FK__UM_ROLE_P__ROLE___0F975522	Cascade	ROLE_ID->[dbo].[UM_ROLES].[ID]

Name

Delete

Columns

FK__UM_ROLE_P__PERMI__0EA330E9

Cascade

PERMISSION_ID->[dbo].[UM_PERMISSIONS].[ID]

FK__UM_ROLE_P__ROLE___0F975522

Cascade

ROLE_ID->[dbo].[UM_ROLES].[ID]

SQL Script

CREATE TABLE [dbo].[UM_ROLE_PERMISSIONS]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[PERMISSION_ID] [int] NOT NULL,
[ROLE_ID] [int] NOT NULL,
[IS_ALLOWED] [smallint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UM_ROLE_PERMISSIONS] ADD CONSTRAINT [PK__UM_ROLE_PERMISSI__0CBAE877] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UM_ROLE_PERMISSIONS] ADD CONSTRAINT [UQ__UM_ROLE_PERMISSI__0DAF0CB0] UNIQUE NONCLUSTERED ([PERMISSION_ID], [ROLE_ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UM_ROLE_PERMISSIONS] ADD CONSTRAINT [FK__UM_ROLE_P__PERMI__0EA330E9] FOREIGN KEY ([PERMISSION_ID]) REFERENCES [dbo].[UM_PERMISSIONS] ([ID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[UM_ROLE_PERMISSIONS] ADD CONSTRAINT [FK__UM_ROLE_P__ROLE___0F975522] FOREIGN KEY ([ROLE_ID]) REFERENCES [dbo].[UM_ROLES] ([ID]) ON DELETE CASCADE
GO