Tables Relationships Utility Tables Constraints Anomalies Columns Download Rice 2.0 Schema Spy zip

Table rice-2.0.krsb_qrtz_triggers | Generated by SchemaSpy

Implied relationships Related columns Constraints Comments Legend |
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
--- | --- | --- | --- | --- | --- | --- | --- | ---
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 Mon May 07 20:18 PDT 2012

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: