Table ocum.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 200
qrtz_blob_triggers.TRIGGER_NAME qrtz_blob_triggers_ibfk_1 R
qrtz_cron_triggers.TRIGGER_NAME qrtz_cron_triggers_ibfk_1 R
qrtz_simple_triggers.TRIGGER_NAME qrtz_simple_triggers_ibfk_1 R
qrtz_simprop_triggers.TRIGGER_NAME qrtz_simprop_triggers_ibfk_1 R
TRIGGER_GROUP varchar 200
qrtz_blob_triggers.TRIGGER_GROUP qrtz_blob_triggers_ibfk_1 R
qrtz_cron_triggers.TRIGGER_GROUP qrtz_cron_triggers_ibfk_1 R
qrtz_simple_triggers.TRIGGER_GROUP qrtz_simple_triggers_ibfk_1 R
qrtz_simprop_triggers.TRIGGER_GROUP qrtz_simprop_triggers_ibfk_1 R
JOB_NAME varchar 200
qrtz_job_details.JOB_NAME qrtz_triggers_ibfk_1 R
JOB_GROUP varchar 200
qrtz_job_details.JOB_GROUP qrtz_triggers_ibfk_1 R
DESCRIPTION varchar 250  √  null
NEXT_FIRE_TIME bigint 19  √  null
PREV_FIRE_TIME bigint 19  √  null
PRIORITY int 10  √  null
TRIGGER_STATE varchar 16
TRIGGER_TYPE varchar 8
START_TIME bigint 19
END_TIME bigint 19  √  null
CALENDAR_NAME varchar 200  √  null
MISFIRE_INSTR smallint 5  √  null
JOB_DATA blob 65535  √  null
SCHED_NAME varchar 120 unifiedManagerScheduler
qrtz_blob_triggers.SCHED_NAME qrtz_blob_triggers_ibfk_1 R
qrtz_cron_triggers.SCHED_NAME qrtz_cron_triggers_ibfk_1 R
qrtz_simple_triggers.SCHED_NAME qrtz_simple_triggers_ibfk_1 R
qrtz_simprop_triggers.SCHED_NAME qrtz_simprop_triggers_ibfk_1 R
qrtz_job_details.SCHED_NAME qrtz_triggers_ibfk_1 R

Table contained 5 rows at Tue Apr 23 05:29 EDT 2019

Indexes:
Column(s) Type Sort Constraint Name
SCHED_NAME + TRIGGER_NAME + TRIGGER_GROUP Primary key Asc/Asc/Asc PRIMARY
SCHED_NAME + CALENDAR_NAME Performance Asc/Asc idx_qrtz_t_c
SCHED_NAME + TRIGGER_GROUP Performance Asc/Asc idx_qrtz_t_g
SCHED_NAME + JOB_NAME + JOB_GROUP Performance Asc/Asc/Asc idx_qrtz_t_j
SCHED_NAME + JOB_GROUP Performance Asc/Asc idx_qrtz_t_jg
SCHED_NAME + TRIGGER_GROUP + TRIGGER_STATE Performance Asc/Asc/Asc idx_qrtz_t_n_g_state
SCHED_NAME + TRIGGER_NAME + TRIGGER_GROUP + TRIGGER_STATE Performance Asc/Asc/Asc/Asc idx_qrtz_t_n_state
SCHED_NAME + NEXT_FIRE_TIME Performance Asc/Asc idx_qrtz_t_next_fire_time
SCHED_NAME + MISFIRE_INSTR + NEXT_FIRE_TIME Performance Asc/Asc/Asc idx_qrtz_t_nft_misfire
SCHED_NAME + TRIGGER_STATE + NEXT_FIRE_TIME Performance Asc/Asc/Asc idx_qrtz_t_nft_st
SCHED_NAME + MISFIRE_INSTR + NEXT_FIRE_TIME + TRIGGER_STATE Performance Asc/Asc/Asc/Asc idx_qrtz_t_nft_st_misfire
SCHED_NAME + MISFIRE_INSTR + NEXT_FIRE_TIME + TRIGGER_GROUP + TRIGGER_STATE Performance Asc/Asc/Asc/Asc/Asc idx_qrtz_t_nft_st_misfire_grp
SCHED_NAME + TRIGGER_STATE Performance Asc/Asc idx_qrtz_t_state
JOB_NAME + JOB_GROUP Performance Asc/Asc JOB_NAME

Close relationships: