Table rice-2.2.0-SNAPSHOT.krsb_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 varchar 80
krsb_qrtz_blob_triggers.TRIGGER_NAME KRSB_QRTZ_BLOB_TRIGGERS_TR1 R
krsb_qrtz_cron_triggers.TRIGGER_NAME KRSB_QRTZ_CRON_TRIGGERS_TR1 R
krsb_qrtz_simple_triggers.TRIGGER_NAME KRSB_QRTZ_SIMPLE_TRIGGERS_TR1 R
krsb_qrtz_trigger_listeners.TRIGGER_NAME KRSB_QRTZ_TRIGGER_LISTENE_TR1 R
TRIGGER_GROUP varchar 80
krsb_qrtz_blob_triggers.TRIGGER_GROUP KRSB_QRTZ_BLOB_TRIGGERS_TR1 R
krsb_qrtz_cron_triggers.TRIGGER_GROUP KRSB_QRTZ_CRON_TRIGGERS_TR1 R
krsb_qrtz_simple_triggers.TRIGGER_GROUP KRSB_QRTZ_SIMPLE_TRIGGERS_TR1 R
krsb_qrtz_trigger_listeners.TRIGGER_GROUP KRSB_QRTZ_TRIGGER_LISTENE_TR1 R
krsb_qrtz_paused_trigger_grps.TRIGGER_GROUP Implied Constraint R
JOB_NAME varchar 80
JOB_GROUP varchar 80
IS_VOLATILE varchar 1
DESCRIPTION varchar 120  √  null
NEXT_FIRE_TIME decimal 13  √  null
PREV_FIRE_TIME decimal 13  √  null
PRIORITY decimal 13  √  null
TRIGGER_STATE varchar 16
TRIGGER_TYPE varchar 8
START_TIME decimal 13
END_TIME decimal 13  √  null
CALENDAR_NAME varchar 80  √  null
krsb_qrtz_calendars.CALENDAR_NAME Implied Constraint R
MISFIRE_INSTR decimal 2  √  null
JOB_DATA longblob 2147483647  √  null

Table contained 0 rows at Fri May 10 14:36 PDT 2013

Indexes:
Column(s) Type Sort Constraint Name
TRIGGER_NAME + TRIGGER_GROUP Primary key Asc/Asc PRIMARY
NEXT_FIRE_TIME Performance Asc KRSB_QRTZ_TRIGGERS_TI1
NEXT_FIRE_TIME + TRIGGER_STATE Performance Asc/Asc KRSB_QRTZ_TRIGGERS_TI2
TRIGGER_STATE Performance Asc KRSB_QRTZ_TRIGGERS_TI3
IS_VOLATILE Performance Asc KRSB_QRTZ_TRIGGERS_TI4

Close relationships: