Table rice-2.2.0-SNAPSHOT.krsb_qrtz_fired_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
ENTRY_ID varchar 95
TRIGGER_NAME varchar 80
TRIGGER_GROUP varchar 80
krsb_qrtz_paused_trigger_grps.TRIGGER_GROUP Implied Constraint R
IS_VOLATILE varchar 1
INSTANCE_NAME varchar 80
krsb_qrtz_scheduler_state.INSTANCE_NAME Implied Constraint R
FIRED_TIME decimal 13
PRIORITY decimal 13
STATE varchar 16
JOB_NAME varchar 80  √  null
JOB_GROUP varchar 80  √  null
IS_STATEFUL varchar 1  √  null
REQUESTS_RECOVERY varchar 1  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
ENTRY_ID Primary key Asc PRIMARY
JOB_GROUP Performance Asc KRSB_QRTZ_FIRED_TRIGGERS_TI1
JOB_NAME Performance Asc KRSB_QRTZ_FIRED_TRIGGERS_TI2
REQUESTS_RECOVERY Performance Asc KRSB_QRTZ_FIRED_TRIGGERS_TI3
IS_STATEFUL Performance Asc KRSB_QRTZ_FIRED_TRIGGERS_TI4
TRIGGER_GROUP Performance Asc KRSB_QRTZ_FIRED_TRIGGERS_TI5
INSTANCE_NAME Performance Asc KRSB_QRTZ_FIRED_TRIGGERS_TI6
TRIGGER_NAME Performance Asc KRSB_QRTZ_FIRED_TRIGGERS_TI7
TRIGGER_NAME + TRIGGER_GROUP Performance Asc/Asc KRSB_QRTZ_FIRED_TRIGGERS_TI8
IS_VOLATILE Performance Asc KRSB_QRTZ_FIRED_TRIGGERS_TI9

Close relationships: