[cohesion].[cc_module

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

Property

Value

Row Count

9000

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)	Allow Nulls
$Cluster Primary Key PK__cc_module_elem__267ABA7A: module_id\element_id$	module_id	int	4
$Cluster Primary Key PK__cc_module_elem__267ABA7A: module_id\element_id$	element_id	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK__cc_module_elem__267ABA7A: module_id\element_id$

module_id

int

$Cluster Primary Key PK__cc_module_elem__267ABA7A: module_id\element_id$

element_id

int

	Name	Columns
$Cluster Primary Key PK__cc_module_elem__267ABA7A: module_id\element_id$	PK__cc_module_elem__267ABA7A	module_id, element_id
	XIE1cc_module_elem	element_id
	XIE2cc_module_elem	module_id

Name

Columns

Unique

$Cluster Primary Key PK__cc_module_elem__267ABA7A: module_id\element_id$

PK__cc_module_elem__267ABA7A

module_id, element_id

XIE1cc_module_elem

element_id

XIE2cc_module_elem

module_id

Name	Columns
FK__cc_module__eleme__276EDEB3	element_id->[cohesion].[cc_element].[element_id]
FK__cc_module__modul__286302EC	module_id->[cohesion].[cc_module].[module_id]

Name

Columns

FK__cc_module__eleme__276EDEB3

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

FK__cc_module__modul__286302EC

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

SQL Script

CREATE TABLE [cohesion].[cc_module_elem]
(
[module_id] [int] NOT NULL,
[element_id] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_module_elem] ADD CONSTRAINT [PK__cc_module_elem__267ABA7A] PRIMARY KEY CLUSTERED ([module_id], [element_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1cc_module_elem] ON [cohesion].[cc_module_elem] ([element_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE2cc_module_elem] ON [cohesion].[cc_module_elem] ([module_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_module_elem] ADD CONSTRAINT [FK__cc_module__eleme__276EDEB3] FOREIGN KEY ([element_id]) REFERENCES [cohesion].[cc_element] ([element_id])
GO
ALTER TABLE [cohesion].[cc_module_elem] ADD CONSTRAINT [FK__cc_module__modul__286302EC] FOREIGN KEY ([module_id]) REFERENCES [cohesion].[cc_module] ([module_id])
GO