[cohesion].[cc

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	62
Created	11:18:09 AM Friday, April 20, 2007
Last Modified	9:08:39 PM Wednesday, August 20, 2008

	Name	Data Type	Max Length (Bytes)	Default
	host_id	int	4
	platform_id	int	4
$Indexes XAK1cc_host: host_name\domain_name\ip_address\mac_address$	host_name	varchar(90)	90
$Indexes XAK1cc_host: host_name\domain_name\ip_address\mac_address$	domain_name	varchar(90)	90
$Indexes XAK1cc_host: host_name\domain_name\ip_address\mac_address$	ip_address	varchar(50)	50
$Indexes XAK1cc_host: host_name\domain_name\ip_address\mac_address$	mac_address	varchar(40)	40
	host_state	smallint	2	((1))
	host_status	smallint	2	((1))
	cc_agent_yn	smallint	2	((1))
	cc_agent_port	int	4
	cc_agent_protocol	smallint	2
	cc_agent_instdir	varchar(90)	90
	cc_agent_instdate	datetime	8
	cc_agent_version	varchar(90)	90
	cc_agent_logging	smallint	2
	cc_agent_pinging	smallint	2
	cc_agent_contact	datetime	8
	cc_agent_alive	smallint	2	((1))
	virtual	smallint	2	((0))
	physical_parent_id	int	4
	virtualization	varchar(255)	255
	created_by	int	4
	creation_time	datetime	8
	ipv4_address	varchar(50)	50
	ipv6_address	varchar(50)	50

	Name	Columns	Unique
	PK__cc_host__7F60ED59	host_id
	XAK1cc_host	host_name, domain_name, ip_address, mac_address

Name	Columns
FK__cc_host__physica__0519C6AF	physical_parent_id->[cohesion].[cc_host].[host_id]
FK__cc_host__platfor__060DEAE8	platform_id->[cohesion].[cc_platform].[platform_id]

SQL Script

CREATE TABLE [cohesion].[cc_host]
(
[host_id] [int] NOT NULL,
[platform_id] [int] NULL,
[host_name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[domain_name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ip_address] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mac_address] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[host_state] [smallint] NULL CONSTRAINT [DF__cc_host__host_st__00551192] DEFAULT ((1)),
[host_status] [smallint] NULL CONSTRAINT [DF__cc_host__host_st__014935CB] DEFAULT ((1)),
[cc_agent_yn] [smallint] NULL CONSTRAINT [DF__cc_host__cc_agen__023D5A04] DEFAULT ((1)),
[cc_agent_port] [int] NULL,
[cc_agent_protocol] [smallint] NULL,
[cc_agent_instdir] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cc_agent_instdate] [datetime] NULL,
[cc_agent_version] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cc_agent_logging] [smallint] NULL,
[cc_agent_pinging] [smallint] NULL,
[cc_agent_contact] [datetime] NULL,
[cc_agent_alive] [smallint] NULL CONSTRAINT [DF__cc_host__cc_agen__03317E3D] DEFAULT ((1)),
[virtual] [smallint] NULL CONSTRAINT [DF__cc_host__virtual__0425A276] DEFAULT ((0)),
[physical_parent_id] [int] NULL,
[virtualization] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[created_by] [int] NULL,
[creation_time] [datetime] NULL,
[ipv4_address] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ipv6_address] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_host] ADD CONSTRAINT [PK__cc_host__7F60ED59] PRIMARY KEY CLUSTERED ([host_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [XAK1cc_host] ON [cohesion].[cc_host] ([host_name], [domain_name], [ip_address], [mac_address]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_host] ADD CONSTRAINT [FK__cc_host__physica__0519C6AF] FOREIGN KEY ([physical_parent_id]) REFERENCES [cohesion].[cc_host] ([host_id])
GO
ALTER TABLE [cohesion].[cc_host] ADD CONSTRAINT [FK__cc_host__platfor__060DEAE8] FOREIGN KEY ([platform_id]) REFERENCES [cohesion].[cc_platform] ([platform_id])
GO