[cohesion].[cc_host

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

Property

Value

Row Count

136

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)	Default
$Cluster Primary Key PK__cc_host_elem__5629CD9C: host_id\element_id$	host_id	int	4
$Cluster Primary Key PK__cc_host_elem__5629CD9C: host_id\element_id$	element_id	int	4
	host_elem_state	smallint	2	((1))

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Cluster Primary Key PK__cc_host_elem__5629CD9C: host_id\element_id$

host_id

int

$Cluster Primary Key PK__cc_host_elem__5629CD9C: host_id\element_id$

element_id

int

host_elem_state

smallint

((1))

	Name	Columns	Unique
$Cluster Primary Key PK__cc_host_elem__5629CD9C: host_id\element_id$	PK__cc_host_elem__5629CD9C	host_id, element_id

Name

Columns

Unique

$Cluster Primary Key PK__cc_host_elem__5629CD9C: host_id\element_id$

PK__cc_host_elem__5629CD9C

host_id, element_id

Name	Columns
FK__cc_host_e__eleme__59063A47	element_id->[cohesion].[cc_element].[element_id]
FK__cc_host_e__host___5812160E	host_id->[cohesion].[cc_host].[host_id]

Name

Columns

FK__cc_host_e__eleme__59063A47

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

FK__cc_host_e__host___5812160E

host_id->[cohesion].[cc_host].[host_id]

SQL Script

CREATE TABLE [cohesion].[cc_host_elem]
(
[host_id] [int] NOT NULL,
[element_id] [int] NOT NULL,
[host_elem_state] [smallint] NULL CONSTRAINT [DF__cc_host_e__host___571DF1D5] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_host_elem] ADD CONSTRAINT [PK__cc_host_elem__5629CD9C] PRIMARY KEY CLUSTERED ([host_id], [element_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_host_elem] ADD CONSTRAINT [FK__cc_host_e__eleme__59063A47] FOREIGN KEY ([element_id]) REFERENCES [cohesion].[cc_element] ([element_id])
GO
ALTER TABLE [cohesion].[cc_host_elem] ADD CONSTRAINT [FK__cc_host_e__host___5812160E] FOREIGN KEY ([host_id]) REFERENCES [cohesion].[cc_host] ([host_id])
GO