CREATE TABLE [cohesion].[cc_ci]
(
[ci_id] [int] NOT NULL,
[ci_current_pointer] [datetime] NOT NULL,
[application_id] [int] NULL,
[module_id] [int] NULL,
[blueprint_id] [int] NULL,
[host_id] [int] NULL,
[element_id] [int] NULL,
[ci_durable_ref] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ci_name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ci_desc] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ci_base_class] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ci_class] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ci_mgmt_type] [smallint] NULL,
[created_by] [int] NULL,
[creation_time] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_ci] ADD CONSTRAINT [PK__cc_ci__76969D2E] PRIMARY KEY CLUSTERED ([ci_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_ci] ADD CONSTRAINT [FK__cc_ci__applicati__787EE5A0] FOREIGN KEY ([application_id]) REFERENCES [cohesion].[cc_application] ([application_id])
GO
ALTER TABLE [cohesion].[cc_ci] ADD CONSTRAINT [FK__cc_ci__blueprint__7A672E12] FOREIGN KEY ([blueprint_id]) REFERENCES [cohesion].[cc_module] ([module_id])
GO
ALTER TABLE [cohesion].[cc_ci] ADD CONSTRAINT [FK__cc_ci__element_i__778AC167] FOREIGN KEY ([element_id]) REFERENCES [cohesion].[cc_element] ([element_id])
GO
ALTER TABLE [cohesion].[cc_ci] ADD CONSTRAINT [FK__cc_ci__host_id__797309D9] FOREIGN KEY ([host_id]) REFERENCES [cohesion].[cc_host] ([host_id])
GO
ALTER TABLE [cohesion].[cc_ci] ADD CONSTRAINT [FK__cc_ci__module_id__7B5B524B] FOREIGN KEY ([module_id]) REFERENCES [cohesion].[cc_module] ([module_id])
GO