[dbo].[UM_ROLE_ATTRIBUTES]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

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
ATTR_NAME	varchar(255)	255
ATTR_VALUE	varchar(255)	255
ROLE_ID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

Cluster Primary Key PK__UM_ROLE_ATTRIBUT__07F6335A: ID

int

1 - 1

ATTR_NAME

varchar(255)

255

ATTR_VALUE

varchar(255)

255

ROLE_ID

int

	Name	Columns	Unique
	PK__UM_ROLE_ATTRIBUT__07F6335A	ID

Name

Columns

Unique

PK__UM_ROLE_ATTRIBUT__07F6335A

Name	Delete	Columns
FK__UM_ROLE_A__ROLE___08EA5793	Cascade	ROLE_ID->[dbo].[UM_ROLES].[ID]

Name

Delete

Columns

FK__UM_ROLE_A__ROLE___08EA5793

Cascade

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

SQL Script

CREATE TABLE [dbo].[UM_ROLE_ATTRIBUTES]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[ATTR_NAME] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ATTR_VALUE] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ROLE_ID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UM_ROLE_ATTRIBUTES] ADD CONSTRAINT [PK__UM_ROLE_ATTRIBUT__07F6335A] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UM_ROLE_ATTRIBUTES] ADD CONSTRAINT [FK__UM_ROLE_A__ROLE___08EA5793] FOREIGN KEY ([ROLE_ID]) REFERENCES [dbo].[UM_ROLES] ([ID]) ON DELETE CASCADE
GO