CREATE TABLE [cohesion].[cc_ci_relation]
(
[rel_id] [int] NOT NULL,
[ci_id_one] [int] NULL,
[ci_one_node_name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ci_one_node_value] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ci_id_two] [int] NULL,
[ci_two_node_name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ci_two_node_value] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[rel_desc] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[rel_base_class] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[rel_class] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[rel_direction] [smallint] NULL,
[rel_protocol] [smallint] NULL,
[rel_osi_layer] [smallint] NULL,
[rel_source] [smallint] NULL,
[rel_strength] [smallint] NULL,
[created_by] [int] NULL,
[creation_time] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_ci_relation] ADD CONSTRAINT [PK__cc_ci_relation__02084FDA] PRIMARY KEY CLUSTERED ([rel_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_ci_relation] ADD CONSTRAINT [FK__cc_ci_rel__ci_id__02FC7413] FOREIGN KEY ([ci_id_two]) REFERENCES [cohesion].[cc_ci] ([ci_id])
GO
ALTER TABLE [cohesion].[cc_ci_relation] ADD CONSTRAINT [FK__cc_ci_rel__ci_id__03F0984C] FOREIGN KEY ([ci_id_one]) REFERENCES [cohesion].[cc_ci] ([ci_id])
GO