JOBSUMMARY

 

Column Descriptions:

NameTypeDescription
JOBSUMMARY_IDBIGINT NOT NULL
JOBSTATUS_IDBIGINT NOT NULL
SEQUENCESMALLINT NOT NULL DEFAULT 1
SUMMARYCLOB (10000000)
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0

Indexes:

NameColumn NamesType
P_JOBSUMMARYJOBSUMMARY_IDPrimary Key
I_JOBSUMMARY_U1JOBSTATUS_ID+SEQUENCEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_JOBSUMMARY_1JOBSTATUS_IDJOBSTATUSJOBSTATUS_IDCascade