CREATE TABLE [dbo].[das_groupjob]
(
[jobgroupid] [decimal] (10, 0) NOT NULL,
[runsequence] [decimal] (10, 0) NOT NULL,
[actionid] [decimal] (10, 0) NOT NULL,
[jobnumpergroup] [int] NULL,
[starttime] [datetime] NULL,
[jobnumsucc] [int] NULL,
[jobnumfailed] [int] NULL,
[jobnumstart] [int] NULL,
[endtime] [datetime] NULL,
[actiontype] [int] NOT NULL,
[anlydefid] [decimal] (10, 0) NULL,
[policyid] [decimal] (10, 0) NULL,
[recmndid] [decimal] (10, 0) NULL,
[productcode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[das_groupjob] ADD CONSTRAINT [das_groupjobpkey] PRIMARY KEY CLUSTERED ([jobgroupid], [runsequence], [actionid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [$das_g_u00001a1b00000000] ON [dbo].[das_groupjob] ([actiontype]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[das_groupjob] TO [udmadmin_group]
GRANT INSERT ON  [dbo].[das_groupjob] TO [udmadmin_group]
GRANT DELETE ON  [dbo].[das_groupjob] TO [udmadmin_group]
GRANT UPDATE ON  [dbo].[das_groupjob] TO [udmadmin_group]
GO