[cohesion].[cc_host_group]
CREATE TABLE [cohesion].[cc_host_group]
(
[host_group_id] [int] NOT NULL,
[host_group_name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[host_group_desc] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[host_group_type] [smallint] NULL,
[parent_group_id] [int] NULL,
[host_group_state] [smallint] NULL CONSTRAINT [DF__cc_host_g__host___1B0907CE] DEFAULT ((1)),
[created_by] [int] NULL,
[creation_time] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_host_group] ADD CONSTRAINT [PK__cc_host_group__1A14E395] PRIMARY KEY CLUSTERED ([host_group_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_host_group] ADD CONSTRAINT [FK__cc_host_g__paren__1BFD2C07] FOREIGN KEY ([parent_group_id]) REFERENCES [cohesion].[cc_host_group] ([host_group_id])
GO
![Foreign Keys FK__cc_host_g__paren__1BFD2C07: [cohesion].[cc_host_group].parent_group_id](../../Images/fk.gif)
