CREATE TABLE [cohesion].[cc_module]
(
[module_id] [int] NOT NULL,
[mod_name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mod_short_name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mod_desc] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mod_qualifier] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mod_version] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[platform_id] [int] NULL,
[mod_instance_type] [smallint] NULL,
[mod_instance_of] [int] NULL,
[release_version] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mod_category] [smallint] NULL,
[mod_mgmt_type] [smallint] NULL CONSTRAINT [DF__cc_module__mod_m__21B6055D] DEFAULT ((1)),
[mod_state] [smallint] NULL CONSTRAINT [DF__cc_module__mod_s__22AA2996] DEFAULT ((1)),
[created_by] [int] NULL,
[creation_time] [datetime] NULL,
[mod_time_crc] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__cc_module__mod_t__55F4C372] DEFAULT ('0'),
[mod_time_cumulative_crc] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__cc_module__mod_t__56E8E7AB] DEFAULT ('0'),
[mod_space_crc] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__cc_module__mod_s__57DD0BE4] DEFAULT ('0'),
[mod_space_cumulative_crc] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__cc_module__mod_s__58D1301D] DEFAULT ('0'),
[is_crc_invalid] [smallint] NOT NULL CONSTRAINT [DF__cc_module__is_cr__59C55456] DEFAULT ((0)),
[rc_max_level] [smallint] NOT NULL CONSTRAINT [DF__cc_module__rc_ma__7755B73D] DEFAULT ((99)),
[rc_default_max_level] [smallint] NOT NULL CONSTRAINT [DF__cc_module__rc_de__7849DB76] DEFAULT ((99)),
[mod_uuid] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[modification_time] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_module] ADD CONSTRAINT [PK__cc_module__20C1E124] PRIMARY KEY CLUSTERED ([module_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1cc_module] ON [cohesion].[cc_module] ([mod_instance_of]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_module] ADD CONSTRAINT [FK__cc_module__mod_i__24927208] FOREIGN KEY ([mod_instance_of]) REFERENCES [cohesion].[cc_module] ([module_id])
GO
ALTER TABLE [cohesion].[cc_module] ADD CONSTRAINT [FK__cc_module__platf__239E4DCF] FOREIGN KEY ([platform_id]) REFERENCES [cohesion].[cc_platform] ([platform_id])
GO