[cohesion].[cc_host

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

Property

Value

Row Count

208

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)
	host_map_id	int	4
$Indexes XAK1cc_host_map: host_id\host_group_id\host_type_id$	host_id	int	4
$Indexes XAK1cc_host_map: host_id\host_group_id\host_type_id$	host_group_id	int	4
$Indexes XAK1cc_host_map: host_id\host_group_id\host_type_id$	host_type_id	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

host_map_id

int

$Indexes XAK1cc_host_map: host_id\host_group_id\host_type_id$

host_id

int

$Indexes XAK1cc_host_map: host_id\host_group_id\host_type_id$

host_group_id

int

$Indexes XAK1cc_host_map: host_id\host_group_id\host_type_id$

host_type_id

int

	Name	Columns	Unique
	PK__cc_host_map__49C3F6B7	host_map_id
	XAK1cc_host_map	host_id, host_group_id, host_type_id

Name

Columns

Unique

PK__cc_host_map__49C3F6B7

host_map_id

XAK1cc_host_map

host_id, host_group_id, host_type_id

Name	Columns
FK__cc_host_m__host___4AB81AF0	host_group_id->[cohesion].[cc_host_group].[host_group_id]
FK__cc_host_m__host___4BAC3F29	host_type_id->[cohesion].[cc_host_type].[host_type_id]
FK__cc_host_m__host___4CA06362	host_id->[cohesion].[cc_host].[host_id]

Name

Columns

FK__cc_host_m__host___4AB81AF0

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

FK__cc_host_m__host___4BAC3F29

host_type_id->[cohesion].[cc_host_type].[host_type_id]

FK__cc_host_m__host___4CA06362

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

SQL Script

CREATE TABLE [cohesion].[cc_host_map]
(
[host_map_id] [int] NOT NULL,
[host_id] [int] NULL,
[host_group_id] [int] NULL,
[host_type_id] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_host_map] ADD CONSTRAINT [PK__cc_host_map__49C3F6B7] PRIMARY KEY CLUSTERED ([host_map_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [XAK1cc_host_map] ON [cohesion].[cc_host_map] ([host_id], [host_group_id], [host_type_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_host_map] ADD CONSTRAINT [FK__cc_host_m__host___4AB81AF0] FOREIGN KEY ([host_group_id]) REFERENCES [cohesion].[cc_host_group] ([host_group_id])
GO
ALTER TABLE [cohesion].[cc_host_map] ADD CONSTRAINT [FK__cc_host_m__host___4BAC3F29] FOREIGN KEY ([host_type_id]) REFERENCES [cohesion].[cc_host_type] ([host_type_id])
GO
ALTER TABLE [cohesion].[cc_host_map] ADD CONSTRAINT [FK__cc_host_m__host___4CA06362] FOREIGN KEY ([host_id]) REFERENCES [cohesion].[cc_host] ([host_id])
GO