[dbo].[UM_USER_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
USER_ID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

Cluster Primary Key PK__UM_USER_ATTRIBUT__023D5A04: ID

int

1 - 1

ATTR_NAME

varchar(255)

255

ATTR_VALUE

varchar(255)

255

USER_ID

int

	Name	Columns	Unique
	PK__UM_USER_ATTRIBUT__023D5A04	ID

Name

Columns

Unique

PK__UM_USER_ATTRIBUT__023D5A04

Name	Delete	Columns
FK__UM_USER_A__USER___03317E3D	Cascade	USER_ID->[dbo].[UM_USERS].[ID]

Name

Delete

Columns

FK__UM_USER_A__USER___03317E3D

Cascade

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

SQL Script

CREATE TABLE [dbo].[UM_USER_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,
[USER_ID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UM_USER_ATTRIBUTES] ADD CONSTRAINT [PK__UM_USER_ATTRIBUT__023D5A04] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UM_USER_ATTRIBUTES] ADD CONSTRAINT [FK__UM_USER_A__USER___03317E3D] FOREIGN KEY ([USER_ID]) REFERENCES [dbo].[UM_USERS] ([ID]) ON DELETE CASCADE
GO