CREATE TABLE [cohesion].[cc_service]
(
[host_id] [int] NOT NULL,
[service_type] [smallint] NOT NULL,
[proxy_id] [int] NULL,
[service_port] [int] NOT NULL,
[tunnel_port] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_service] ADD CONSTRAINT [PK__cc_service__0AD2A005] PRIMARY KEY CLUSTERED ([host_id], [service_type]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_service] ADD CONSTRAINT [FK__cc_servic__host___0CBAE877] FOREIGN KEY ([host_id]) REFERENCES [cohesion].[cc_host] ([host_id])
GO
ALTER TABLE [cohesion].[cc_service] ADD CONSTRAINT [FK__cc_servic__proxy__0BC6C43E] FOREIGN KEY ([proxy_id]) REFERENCES [cohesion].[cc_proxy] ([proxy_id])
GO
[cohesion].[cc_service]
![Foreign Keys FK__cc_servic__host___0CBAE877: [cohesion].[cc_host].host_id](../../Images/fk.gif)
