CREATE TABLE [dbo].[workloadcommon]
(
[jobid] [int] NOT NULL,
[regionid] [int] NULL,
[instancename] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jobname] [varchar] (139) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[jobtype] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[jobleft] [int] NULL,
[jobright] [int] NULL,
[jobtop] [int] NULL,
[jobbottom] [int] NULL,
[cloneid] [int] NULL,
[templatejobid] [int] NULL,
[checkoutsid] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[checkoutname] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[lastsynctime] [int] NULL,
[lastmodtime] [int] NULL,
[boxjobid] [int] NULL,
[applicationid] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[abendaction] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[anycpu] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[autosel] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[averagetime] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[backlog] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[boxname] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[calendar] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[createdate] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[createtime] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[createuser] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[adjustment] [int] NULL,
[critcal] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[crithact] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[critnwact] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[critkeys] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[earlytime] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[effectivedate] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[expiresdate] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[failcondl] [int] NULL,
[failcondh] [int] NULL,
[history] [int] NULL,
[hold] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[maxtime] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mustcomptime] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[muststarttime] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[subuserid] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[subdomain] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[subpass] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[priority] [int] NULL,
[skip] [int] NULL,
[station] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[updatedate] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[updatetime] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[updateuser] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[userenv] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[wk_condition] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jobnumber] [int] NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_workloadcommon] ON [dbo].[workloadcommon] ([jobid]) ON [PRIMARY]
GO