[dbo].[al_link_attribute

Property	Value
Row Count	0
Created	10:33:04 PM Thursday, February 10, 2011
Last Modified	10:33:04 PM Thursday, February 10, 2011

Property

Value

Row Count

Created

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

Last Modified

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

	Name	Data Type	Collation	Max Length (Bytes)
$Cluster Primary Key xpkal_link_attribute_hierarchy: class_name\attribute_name\config_id$	class_name	nvarchar(255)	SQL_Latin1_General_CP1_CI_AS	510
$Cluster Primary Key xpkal_link_attribute_hierarchy: class_name\attribute_name\config_id$	attribute_name	nvarchar(255)	SQL_Latin1_General_CP1_CI_AS	510
$Cluster Primary Key xpkal_link_attribute_hierarchy: class_name\attribute_name\config_id$	config_id	int		4
	hierarchy_id	int		4
	creation_user	nvarchar(255)	SQL_Latin1_General_CP1_CS_AS	510
	creation_date	int		4
	last_update_user	nvarchar(255)	SQL_Latin1_General_CP1_CS_AS	510
	last_update_date	int		4
	version_number	int		4

Name

Data Type

Collation

Max Length (Bytes)

Allow Nulls

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

class_name

nvarchar(255)

SQL_Latin1_General_CP1_CI_AS

510

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

attribute_name

nvarchar(255)

SQL_Latin1_General_CP1_CI_AS

510

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

config_id

int

hierarchy_id

int

creation_user

nvarchar(255)

SQL_Latin1_General_CP1_CS_AS

510

creation_date

int

last_update_user

nvarchar(255)

SQL_Latin1_General_CP1_CS_AS

510

last_update_date

int

version_number

int

	Name	Columns	Unique
$Cluster Primary Key xpkal_link_attribute_hierarchy: class_name\attribute_name\config_id$	xpkal_link_attribute_hierarchy	class_name, attribute_name, config_id

Name

Columns

Unique

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

xpkal_link_attribute_hierarchy

class_name, attribute_name, config_id

SQL Script

CREATE TABLE [dbo].[al_link_attribute_hierarchy]
(
[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,
[hierarchy_id] [int] NOT NULL,
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[al_link_attribute_hierarchy] ADD CONSTRAINT [xpkal_link_attribute_hierarchy] PRIMARY KEY CLUSTERED ([class_name], [attribute_name], [config_id]) ON [PRIMARY]
GO