[dbo].[UM_USER_PERMISSIONS]

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

Property

Value

Row Count

5552

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_USER_PERMISSI__1273C1CD: PERMISSION_ID\USER_ID$	PERMISSION_ID	int	4
$Indexes UQ__UM_USER_PERMISSI__1273C1CD: PERMISSION_ID\USER_ID$	USER_ID	int	4
	IS_ALLOWED	smallint	2

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

Cluster Primary Key PK__UM_USER_PERMISSI__117F9D94: ID

int

1 - 1

$Indexes UQ__UM_USER_PERMISSI__1273C1CD: PERMISSION_ID\USER_ID$

PERMISSION_ID

int

$Indexes UQ__UM_USER_PERMISSI__1273C1CD: PERMISSION_ID\USER_ID$

USER_ID

int

IS_ALLOWED

smallint

	Name	Columns	Unique
	PK__UM_USER_PERMISSI__117F9D94	ID
	UQ__UM_USER_PERMISSI__1273C1CD	PERMISSION_ID, USER_ID

Name

Columns

Unique

PK__UM_USER_PERMISSI__117F9D94

UQ__UM_USER_PERMISSI__1273C1CD

PERMISSION_ID, USER_ID

Name	Delete	Columns
FK__UM_USER_P__PERMI__1367E606	Cascade	PERMISSION_ID->[dbo].[UM_PERMISSIONS].[ID]
FK__UM_USER_P__USER___145C0A3F	Cascade	USER_ID->[dbo].[UM_USERS].[ID]

Name

Delete

Columns

FK__UM_USER_P__PERMI__1367E606

Cascade

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

FK__UM_USER_P__USER___145C0A3F

Cascade

USER_ID->[dbo].[UM_USERS].[ID]

SQL Script

CREATE TABLE [dbo].[UM_USER_PERMISSIONS]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[PERMISSION_ID] [int] NOT NULL,
[USER_ID] [int] NOT NULL,
[IS_ALLOWED] [smallint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UM_USER_PERMISSIONS] ADD CONSTRAINT [PK__UM_USER_PERMISSI__117F9D94] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UM_USER_PERMISSIONS] ADD CONSTRAINT [UQ__UM_USER_PERMISSI__1273C1CD] UNIQUE NONCLUSTERED ([PERMISSION_ID], [USER_ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UM_USER_PERMISSIONS] ADD CONSTRAINT [FK__UM_USER_P__PERMI__1367E606] FOREIGN KEY ([PERMISSION_ID]) REFERENCES [dbo].[UM_PERMISSIONS] ([ID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[UM_USER_PERMISSIONS] ADD CONSTRAINT [FK__UM_USER_P__USER___145C0A3F] FOREIGN KEY ([USER_ID]) REFERENCES [dbo].[UM_USERS] ([ID]) ON DELETE CASCADE
GO