[dbo].[al_link_attribute

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	71
Created	10:33:04 PM Thursday, February 10, 2011
Last Modified	10:34:18 PM Thursday, February 10, 2011

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

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

Last Modified

10:34:18 PM Thursday, February 10, 2011

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key xpkal_link_attribute_config: class_name\attribute_name\config_id$ $Foreign Keys al_link_attribute_config_fk01: [dbo].[arg_attribute_def].class_name\attribute_name$	class_name	nvarchar(255)	510
$Cluster Primary Key xpkal_link_attribute_config: class_name\attribute_name\config_id$ $Foreign Keys al_link_attribute_config_fk01: [dbo].[arg_attribute_def].class_name\attribute_name$	attribute_name	nvarchar(255)	510
$Cluster Primary Key xpkal_link_attribute_config: class_name\attribute_name\config_id$	config_id	int	4
	required	int	4	('0 ')
	label	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_config: class_name\attribute_name\config_id$ $Foreign Keys al_link_attribute_config_fk01: [dbo].[arg_attribute_def].class_name\attribute_name$

class_name

nvarchar(255)

510

$Cluster Primary Key xpkal_link_attribute_config: class_name\attribute_name\config_id$ $Foreign Keys al_link_attribute_config_fk01: [dbo].[arg_attribute_def].class_name\attribute_name$

attribute_name

nvarchar(255)

510

$Cluster Primary Key xpkal_link_attribute_config: class_name\attribute_name\config_id$

config_id

int

required

int

('0 ')

label

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_config: class_name\attribute_name\config_id$	xpkal_link_attribute_config	class_name, attribute_name, config_id

Name

Columns

Unique

$Cluster Primary Key xpkal_link_attribute_config: class_name\attribute_name\config_id$

xpkal_link_attribute_config

class_name, attribute_name, config_id

Name	Columns
al_link_attribute_config_fk01	class_name->[dbo].[arg_attribute_def].[class_name] attribute_name->[dbo].[arg_attribute_def].[attribute_name]
al_link_attribute_config_fk02	config_id->[dbo].[al_configuration_def].[id]

Name

Columns

al_link_attribute_config_fk01

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

al_link_attribute_config_fk02

config_id->[dbo].[al_configuration_def].[id]

SQL Script

CREATE TABLE [dbo].[al_link_attribute_config]
(
[class_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[attribute_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[config_id] [int] NOT NULL,
[required] [int] NULL CONSTRAINT [DF__AL_LINK_A__REQUI__58671BC9] DEFAULT ('0 '),
[label] [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_LAC_VERSION] DEFAULT ('0')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[al_link_attribute_config] ADD CONSTRAINT [xpkal_link_attribute_config] PRIMARY KEY CLUSTERED ([class_name], [attribute_name], [config_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_link_attribute_config] ADD CONSTRAINT [al_link_attribute_config_fk01] FOREIGN KEY ([class_name], [attribute_name]) REFERENCES [dbo].[arg_attribute_def] ([class_name], [attribute_name])
GO
ALTER TABLE [dbo].[al_link_attribute_config] ADD CONSTRAINT [al_link_attribute_config_fk02] FOREIGN KEY ([config_id]) REFERENCES [dbo].[al_configuration_def] ([id])
GO