[dbo].[al_link_attribute

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	6747
Created	10:33:04 PM Thursday, February 10, 2011
Last Modified	7:00:29 PM Tuesday, April 26, 2011

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

6747

Created

10:33:04 PM Thursday, February 10, 2011

Last Modified

7:00:29 PM Tuesday, April 26, 2011

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key xpkal_link_attribute_security: class_name\attribute_name\security_id$ $Foreign Keys al_link_att_security_fk01: [dbo].[arg_attribute_def].class_name\attribute_name$	attribute_name	nvarchar(255)	510
$Cluster Primary Key xpkal_link_attribute_security: class_name\attribute_name\security_id$	security_id	int	4
$Cluster Primary Key xpkal_link_attribute_security: class_name\attribute_name\security_id$ $Foreign Keys al_link_att_security_fk01: [dbo].[arg_attribute_def].class_name\attribute_name$	class_name	nvarchar(255)	510
	root_class_name	nvarchar(255)	510
	creation_user	nvarchar(255)	510
	creation_date	int	4
	last_update_user	nvarchar(255)	510
	last_update_date	int	4
	version_number	int	4	('0')

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Cluster Primary Key xpkal_link_attribute_security: class_name\attribute_name\security_id$ $Foreign Keys al_link_att_security_fk01: [dbo].[arg_attribute_def].class_name\attribute_name$

attribute_name

nvarchar(255)

510

$Cluster Primary Key xpkal_link_attribute_security: class_name\attribute_name\security_id$

security_id

int

$Cluster Primary Key xpkal_link_attribute_security: class_name\attribute_name\security_id$ $Foreign Keys al_link_att_security_fk01: [dbo].[arg_attribute_def].class_name\attribute_name$

class_name

nvarchar(255)

510

root_class_name

nvarchar(255)

510

creation_user

nvarchar(255)

510

creation_date

int

last_update_user

nvarchar(255)

510

last_update_date

int

version_number

int

('0')

	Name	Columns	Unique
$Cluster Primary Key xpkal_link_attribute_security: class_name\attribute_name\security_id$	xpkal_link_attribute_security	class_name, attribute_name, security_id

Name

Columns

Unique

$Cluster Primary Key xpkal_link_attribute_security: class_name\attribute_name\security_id$

xpkal_link_attribute_security

class_name, attribute_name, security_id

Name	No Check	Columns
al_link_att_security_fk01		class_name->[dbo].[arg_attribute_def].[class_name] attribute_name->[dbo].[arg_attribute_def].[attribute_name]
al_link_att_security_fk02		security_id->[dbo].[al_security_identifier].[id]
al_link_att_security_fk03		root_class_name->[dbo].[arg_class_def].[class_name]

Name

No Check

Columns

al_link_att_security_fk01

class_name->[dbo].[arg_attribute_def].[class_name]
attribute_name->[dbo].[arg_attribute_def].[attribute_name]

al_link_att_security_fk02

security_id->[dbo].[al_security_identifier].[id]

al_link_att_security_fk03

root_class_name->[dbo].[arg_class_def].[class_name]

SQL Script

CREATE TABLE [dbo].[al_link_attribute_security]
(
[attribute_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[security_id] [int] NOT NULL,
[class_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[root_class_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF_LAS_VERSION] DEFAULT ('0')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[al_link_attribute_security] ADD CONSTRAINT [xpkal_link_attribute_security] PRIMARY KEY CLUSTERED ([class_name], [attribute_name], [security_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_link_attribute_security] WITH NOCHECK ADD CONSTRAINT [al_link_att_security_fk01] FOREIGN KEY ([class_name], [attribute_name]) REFERENCES [dbo].[arg_attribute_def] ([class_name], [attribute_name])
GO
ALTER TABLE [dbo].[al_link_attribute_security] ADD CONSTRAINT [al_link_att_security_fk02] FOREIGN KEY ([security_id]) REFERENCES [dbo].[al_security_identifier] ([id])
GO
ALTER TABLE [dbo].[al_link_attribute_security] ADD CONSTRAINT [al_link_att_security_fk03] FOREIGN KEY ([root_class_name]) REFERENCES [dbo].[arg_class_def] ([class_name])
GO