CREATE TABLE [cohesion].[cc_role]
(
[role_id] [int] NOT NULL,
[role_name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[role_desc] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[role_state] [smallint] NULL CONSTRAINT [DF__cc_role__role_st__34C8D9D1] DEFAULT ((1)),
[perm_bitset] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[modify_time] [datetime] NULL,
[created_by] [int] NULL,
[creation_time] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_role] ADD CONSTRAINT [PK__cc_role__33D4B598] PRIMARY KEY CLUSTERED ([role_id]) ON [PRIMARY]
GO
[cohesion].[cc_role]
