Table lawprod.MSCM.MSCM9_TASK Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
TASKID number 19
VERSION varchar2 5
ROW_VERSION number 10
TASKTYPE number 10
TASKSUSPENDED number 1
CANCELLED number 1
NEXTFIRETIME number 19
STARTBYINTERVAL varchar2 254  √  null
STARTBYTIME number 19  √  null
VALIDFROMTIME number 19  √  null
VALIDTOTIME number 19  √  null
REPEATINTERVAL varchar2 254  √  null
MAXREPEATS number 10
REPEATSLEFT number 10
TASKINFO blob 4000  √  null
NAME varchar2 254  √  null
AUTOPURGE number 10
FAILUREACTION number 10  √  null
MAXATTEMPTS number 10  √  null
QOS number 10  √  null
PARTITIONID number 10  √  null
OWNERTOKEN varchar2 200
CREATETIME number 19

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
TASKID Primary key Asc SYS_C001030885
TASKID + OWNERTOKEN Performance Asc/Asc MSCM9_TASK_IDX1
NEXTFIRETIME + REPEATSLEFT + PARTITIONID Performance Asc/Asc/Asc MSCM9_TASK_IDX2