[dbo].[UM_USER

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

Property

Value

Row Count

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_ROLES__173876EA: USER_ID\ROLE_ID$	ROLE_ID	int	4
$Indexes UQ__UM_USER_ROLES__173876EA: USER_ID\ROLE_ID$	USER_ID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

Cluster Primary Key PK__UM_USER_ROLES__164452B1: ID

int

1 - 1

$Indexes UQ__UM_USER_ROLES__173876EA: USER_ID\ROLE_ID$

ROLE_ID

int

$Indexes UQ__UM_USER_ROLES__173876EA: USER_ID\ROLE_ID$

USER_ID

int

	Name	Columns	Unique
	PK__UM_USER_ROLES__164452B1	ID
	UQ__UM_USER_ROLES__173876EA	USER_ID, ROLE_ID

Name

Columns

Unique

PK__UM_USER_ROLES__164452B1

UQ__UM_USER_ROLES__173876EA

USER_ID, ROLE_ID

Name	Delete	Columns
FK__UM_USER_R__ROLE___182C9B23	Cascade	ROLE_ID->[dbo].[UM_ROLES].[ID]
FK__UM_USER_R__USER___1920BF5C	Cascade	USER_ID->[dbo].[UM_USERS].[ID]

Name

Delete

Columns

FK__UM_USER_R__ROLE___182C9B23

Cascade

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

FK__UM_USER_R__USER___1920BF5C

Cascade

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

SQL Script

CREATE TABLE [dbo].[UM_USER_ROLES]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[ROLE_ID] [int] NOT NULL,
[USER_ID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UM_USER_ROLES] ADD CONSTRAINT [PK__UM_USER_ROLES__164452B1] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UM_USER_ROLES] ADD CONSTRAINT [UQ__UM_USER_ROLES__173876EA] UNIQUE NONCLUSTERED ([USER_ID], [ROLE_ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UM_USER_ROLES] ADD CONSTRAINT [FK__UM_USER_R__ROLE___182C9B23] FOREIGN KEY ([ROLE_ID]) REFERENCES [dbo].[UM_ROLES] ([ID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[UM_USER_ROLES] ADD CONSTRAINT [FK__UM_USER_R__USER___1920BF5C] FOREIGN KEY ([USER_ID]) REFERENCES [dbo].[UM_USERS] ([ID]) ON DELETE CASCADE
GO