JOBSTATUS

 

Column Descriptions:

NameTypeDescription
JOBSTATUS_IDBIGINT NOT NULL
USERS_IDBIGINT
JOBTYPEVARCHAR (254) NOT NULL
PROPERTIESVARCHAR (1024)
STARTTIMETIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP
LASTUPDATETIMESTAMP
FINISHTIMETIMESTAMP
STATUSSMALLINT NOT NULL
PROGRESSSMALLINT NOT NULL DEFAULT -1
INTERNALIDVARCHAR (128)
CALLPROGINFOVARCHAR (1024)
STATUSMSGVARCHAR (4000)
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0

Indexes:

NameColumn NamesType
P_JOBSTATUSJOBSTATUS_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_JOBSUMMARY_1JOBSTATUS_IDJOBSUMMARYJOBSTATUS_IDCascade