[cohesion].[cc_app

Property	Value
Row Count	18
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)	Allow Nulls
$Cluster Primary Key PK__cc_app_elem__6477ECF3: application_id\element_id$	application_id	int	4
$Cluster Primary Key PK__cc_app_elem__6477ECF3: application_id\element_id$	element_id	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK__cc_app_elem__6477ECF3: application_id\element_id$

application_id

int

$Cluster Primary Key PK__cc_app_elem__6477ECF3: application_id\element_id$

element_id

int

	Name	Columns	Unique
$Cluster Primary Key PK__cc_app_elem__6477ECF3: application_id\element_id$	PK__cc_app_elem__6477ECF3	application_id, element_id

Name

Columns

Unique

$Cluster Primary Key PK__cc_app_elem__6477ECF3: application_id\element_id$

PK__cc_app_elem__6477ECF3

application_id, element_id

Name	Columns
FK__cc_app_el__appli__66603565	application_id->[cohesion].[cc_application].[application_id]
FK__cc_app_el__eleme__656C112C	element_id->[cohesion].[cc_element].[element_id]

Name

Columns

FK__cc_app_el__appli__66603565

application_id->[cohesion].[cc_application].[application_id]

FK__cc_app_el__eleme__656C112C

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

SQL Script

CREATE TABLE [cohesion].[cc_app_elem]
(
[application_id] [int] NOT NULL,
[element_id] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_app_elem] ADD CONSTRAINT [PK__cc_app_elem__6477ECF3] PRIMARY KEY CLUSTERED ([application_id], [element_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_app_elem] ADD CONSTRAINT [FK__cc_app_el__appli__66603565] FOREIGN KEY ([application_id]) REFERENCES [cohesion].[cc_application] ([application_id])
GO
ALTER TABLE [cohesion].[cc_app_elem] ADD CONSTRAINT [FK__cc_app_el__eleme__656C112C] FOREIGN KEY ([element_id]) REFERENCES [cohesion].[cc_element] ([element_id])
GO