[cohesion].[cc_elem

Property	Value
Row Count	21637
Created	11:18:10 AM Friday, April 20, 2007
Last Modified	11:18:10 AM Friday, April 20, 2007

Property

Value

Row Count

21637

Created

11:18:10 AM Friday, April 20, 2007

Last Modified

11:18:10 AM Friday, April 20, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK__cc_elem_relation__2C3393D0: parent_id\child_id$	parent_id	int	4
$Cluster Primary Key PK__cc_elem_relation__2C3393D0: parent_id\child_id$	child_id	int	4
	sequence_no	int	4
	relationship	smallint	2

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK__cc_elem_relation__2C3393D0: parent_id\child_id$

parent_id

int

$Cluster Primary Key PK__cc_elem_relation__2C3393D0: parent_id\child_id$

child_id

int

sequence_no

int

relationship

smallint

	Name	Columns
$Cluster Primary Key PK__cc_elem_relation__2C3393D0: parent_id\child_id$	PK__cc_elem_relation__2C3393D0	parent_id, child_id
	XIE1cc_elem_relati	child_id
	XIE2cc_elem_relati	parent_id

Name

Columns

Unique

$Cluster Primary Key PK__cc_elem_relation__2C3393D0: parent_id\child_id$

PK__cc_elem_relation__2C3393D0

parent_id, child_id

XIE1cc_elem_relati

child_id

XIE2cc_elem_relati

parent_id

Name	Columns
FK__cc_elem_r__child__2E1BDC42	child_id->[cohesion].[cc_element].[element_id]
FK__cc_elem_r__paren__2D27B809	parent_id->[cohesion].[cc_element].[element_id]

Name

Columns

FK__cc_elem_r__child__2E1BDC42

child_id->[cohesion].[cc_element].[element_id]

FK__cc_elem_r__paren__2D27B809

parent_id->[cohesion].[cc_element].[element_id]

SQL Script

CREATE TABLE [cohesion].[cc_elem_relation]
(
[parent_id] [int] NOT NULL,
[child_id] [int] NOT NULL,
[sequence_no] [int] NOT NULL,
[relationship] [smallint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_elem_relation] ADD CONSTRAINT [PK__cc_elem_relation__2C3393D0] PRIMARY KEY CLUSTERED ([parent_id], [child_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1cc_elem_relati] ON [cohesion].[cc_elem_relation] ([child_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE2cc_elem_relati] ON [cohesion].[cc_elem_relation] ([parent_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_elem_relation] ADD CONSTRAINT [FK__cc_elem_r__child__2E1BDC42] FOREIGN KEY ([child_id]) REFERENCES [cohesion].[cc_element] ([element_id])
GO
ALTER TABLE [cohesion].[cc_elem_relation] ADD CONSTRAINT [FK__cc_elem_r__paren__2D27B809] FOREIGN KEY ([parent_id]) REFERENCES [cohesion].[cc_element] ([element_id])
GO