[cohesion].[cc_module

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

Property

Value

Row Count

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_module_relati__300424B4: parent_id\child_id$	parent_id	int	4
$Cluster Primary Key PK__cc_module_relati__300424B4: 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_module_relati__300424B4: parent_id\child_id$

parent_id

int

$Cluster Primary Key PK__cc_module_relati__300424B4: parent_id\child_id$

child_id

int

sequence_no

int

relationship

smallint

	Name	Columns	Unique
$Cluster Primary Key PK__cc_module_relati__300424B4: parent_id\child_id$	PK__cc_module_relati__300424B4	parent_id, child_id
	XIE1cc_module_rela	child_id

Name

Columns

Unique

$Cluster Primary Key PK__cc_module_relati__300424B4: parent_id\child_id$

PK__cc_module_relati__300424B4

parent_id, child_id

XIE1cc_module_rela

child_id

Name	Columns
FK__cc_module__child__30F848ED	child_id->[cohesion].[cc_module].[module_id]
FK__cc_module__paren__31EC6D26	parent_id->[cohesion].[cc_module].[module_id]

Name

Columns

FK__cc_module__child__30F848ED

child_id->[cohesion].[cc_module].[module_id]

FK__cc_module__paren__31EC6D26

parent_id->[cohesion].[cc_module].[module_id]

SQL Script

CREATE TABLE [cohesion].[cc_module_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_module_relation] ADD CONSTRAINT [PK__cc_module_relati__300424B4] PRIMARY KEY CLUSTERED ([parent_id], [child_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1cc_module_rela] ON [cohesion].[cc_module_relation] ([child_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_module_relation] ADD CONSTRAINT [FK__cc_module__child__30F848ED] FOREIGN KEY ([child_id]) REFERENCES [cohesion].[cc_module] ([module_id])
GO
ALTER TABLE [cohesion].[cc_module_relation] ADD CONSTRAINT [FK__cc_module__paren__31EC6D26] FOREIGN KEY ([parent_id]) REFERENCES [cohesion].[cc_module] ([module_id])
GO