CREATE TABLE [cohesion].[cc_application]
(
[application_id] [int] NOT NULL,
[app_name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[app_short_name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[app_desc] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[app_version] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[app_instance_type] [smallint] NULL,
[app_instance_of] [int] NULL,
[release_version] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cluster_id] [int] NULL,
[is_gold_std] [smallint] NULL CONSTRAINT [DF__cc_applic__is_go__37A5467C] DEFAULT ((0)),
[is_baseline] [smallint] NULL CONSTRAINT [DF__cc_applic__is_ba__38996AB5] DEFAULT ((0)),
[app_state] [smallint] NULL CONSTRAINT [DF__cc_applic__app_s__398D8EEE] DEFAULT ((1)),
[app_notes] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[snap_origin] [smallint] NULL,
[created_by] [int] NULL,
[creation_time] [datetime] NULL,
[app_time_crc] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__cc_applic__app_t__5224328E] DEFAULT ('0'),
[app_time_cumulative_crc] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__cc_applic__app_t__531856C7] DEFAULT ('0'),
[app_space_crc] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__cc_applic__app_s__540C7B00] DEFAULT ('0'),
[app_space_cumulative_crc] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__cc_applic__app_s__55009F39] DEFAULT ('0'),
[rc_max_level] [smallint] NOT NULL CONSTRAINT [DF__cc_applic__rc_ma__756D6ECB] DEFAULT ((99)),
[rc_default_max_level] [smallint] NOT NULL CONSTRAINT [DF__cc_applic__rc_de__76619304] DEFAULT ((99)),
[app_uuid] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[modification_time] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_application] ADD CONSTRAINT [PK__cc_application__36B12243] PRIMARY KEY CLUSTERED ([application_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1cc_application] ON [cohesion].[cc_application] ([app_instance_of]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_application] ADD CONSTRAINT [FK__cc_applic__app_i__3B75D760] FOREIGN KEY ([app_instance_of]) REFERENCES [cohesion].[cc_application] ([application_id])
GO
ALTER TABLE [cohesion].[cc_application] ADD CONSTRAINT [FK__cc_applic__clust__3A81B327] FOREIGN KEY ([cluster_id]) REFERENCES [cohesion].[cc_host_group] ([host_group_id])
GO