CREATE TABLE [cohesion].[cc_element]
(
[element_id] [int] NOT NULL,
[elem_name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[elem_dtype] [smallint] NULL,
[elem_value] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[elem_desc] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[elem_state] [smallint] NULL CONSTRAINT [DF__cc_elemen__elem___1ED998B2] DEFAULT ((1)),
[created_by] [int] NULL,
[creation_time] [datetime] NULL,
[elem_time_crc] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__cc_elemen__elem___5AB9788F] DEFAULT ('0'),
[elem_time_cumulative_crc] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__cc_elemen__elem___5BAD9CC8] DEFAULT ('0'),
[elem_space_crc] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__cc_elemen__elem___5CA1C101] DEFAULT ('0'),
[elem_space_cumulative_crc] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__cc_elemen__elem___5D95E53A] DEFAULT ('0'),
[rc_max_level] [smallint] NOT NULL CONSTRAINT [DF__cc_elemen__rc_ma__793DFFAF] DEFAULT ((99)),
[rc_default_max_level] [smallint] NOT NULL CONSTRAINT [DF__cc_elemen__rc_de__7A3223E8] DEFAULT ((99)),
[elem_uuid] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[modification_time] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_element] ADD CONSTRAINT [PK__cc_element__1DE57479] PRIMARY KEY CLUSTERED ([element_id]) ON [PRIMARY]
GO