Table shrdb.LAWSN.QRTZ_TRIGGERS Generated by
SchemaSpy
Legend: SourceForge.net
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
TRIGGER_NAME varchar2 80
QRTZ_BLOB_TRIGGERS.TRIGGER_NAME SYS_C0011699 R
QRTZ_CRON_TRIGGERS.TRIGGER_NAME SYS_C0011707 R
QRTZ_SIMPLE_TRIGGERS.TRIGGER_NAME SYS_C0011708 R
QRTZ_TRIGGER_LISTENERS.TRIGGER_NAME SYS_C0011706 R
TRIGGER_GROUP varchar2 80
QRTZ_BLOB_TRIGGERS.TRIGGER_GROUP SYS_C0011699 R
QRTZ_CRON_TRIGGERS.TRIGGER_GROUP SYS_C0011707 R
QRTZ_SIMPLE_TRIGGERS.TRIGGER_GROUP SYS_C0011708 R
QRTZ_TRIGGER_LISTENERS.TRIGGER_GROUP SYS_C0011706 R
QRTZ_PAUSED_TRIGGER_GRPS.TRIGGER_GROUP Implied Constraint R
JOB_NAME varchar2 80
QRTZ_JOB_DETAILS.JOB_NAME SYS_C0011700 R
JOB_GROUP varchar2 80
QRTZ_JOB_DETAILS.JOB_GROUP SYS_C0011700 R
IS_VOLATILE varchar2 1
DESCRIPTION varchar2 120  √  null
NEXT_FIRE_TIME number 13  √  null
PREV_FIRE_TIME number 13  √  null
PRIORITY number 13  √  null
TRIGGER_STATE varchar2 16
TRIGGER_TYPE varchar2 8
START_TIME number 13
END_TIME number 13  √  null
CALENDAR_NAME varchar2 80  √  null
QRTZ_CALENDARS.CALENDAR_NAME Implied Constraint R
MISFIRE_INSTR number 2  √  null
JOB_DATA blob 4000  √  null

Table contained 10 rows at Thu Dec 13 15:47 CST 2012

Indexes:
Column(s) Type Sort Constraint Name
TRIGGER_NAME + TRIGGER_GROUP Primary key Asc/Asc SYS_C0011542
NEXT_FIRE_TIME Performance Asc IDX_QRTZ_T_NEXT_FIRE_TIME
NEXT_FIRE_TIME + TRIGGER_STATE Performance Asc/Asc IDX_QRTZ_T_NFT_ST
TRIGGER_STATE Performance Asc IDX_QRTZ_T_STATE
IS_VOLATILE Performance Asc IDX_QRTZ_T_VOLATILE

Close relationships  within of separation: