[cohesion].[cc_host_group

Property	Value
Row Count	8
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)	Default
$Cluster Primary Key PK__cc_host_group_el__71D1E811: host_group_id\element_id$	host_group_id	int	4
$Cluster Primary Key PK__cc_host_group_el__71D1E811: host_group_id\element_id$	element_id	int	4
	group_elem_state	smallint	2	((1))

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Cluster Primary Key PK__cc_host_group_el__71D1E811: host_group_id\element_id$

host_group_id

int

$Cluster Primary Key PK__cc_host_group_el__71D1E811: host_group_id\element_id$

element_id

int

group_elem_state

smallint

((1))

	Name	Columns	Unique
$Cluster Primary Key PK__cc_host_group_el__71D1E811: host_group_id\element_id$	PK__cc_host_group_el__71D1E811	host_group_id, element_id

Name

Columns

Unique

$Cluster Primary Key PK__cc_host_group_el__71D1E811: host_group_id\element_id$

PK__cc_host_group_el__71D1E811

host_group_id, element_id

Name	Columns
FK__cc_host_g__eleme__73BA3083	element_id->[cohesion].[cc_element].[element_id]
FK__cc_host_g__host___74AE54BC	host_group_id->[cohesion].[cc_host_group].[host_group_id]

Name

Columns

FK__cc_host_g__eleme__73BA3083

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

FK__cc_host_g__host___74AE54BC

host_group_id->[cohesion].[cc_host_group].[host_group_id]

SQL Script

CREATE TABLE [cohesion].[cc_host_group_elem]
(
[host_group_id] [int] NOT NULL,
[element_id] [int] NOT NULL,
[group_elem_state] [smallint] NULL CONSTRAINT [DF__cc_host_g__group__72C60C4A] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_host_group_elem] ADD CONSTRAINT [PK__cc_host_group_el__71D1E811] PRIMARY KEY CLUSTERED ([host_group_id], [element_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_host_group_elem] ADD CONSTRAINT [FK__cc_host_g__eleme__73BA3083] FOREIGN KEY ([element_id]) REFERENCES [cohesion].[cc_element] ([element_id])
GO
ALTER TABLE [cohesion].[cc_host_group_elem] ADD CONSTRAINT [FK__cc_host_g__host___74AE54BC] FOREIGN KEY ([host_group_id]) REFERENCES [cohesion].[cc_host_group] ([host_group_id])
GO