Table ocum.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 200
TRIGGER_GROUP varchar 200
INSTANCE_NAME varchar 200
FIRED_TIME bigint 19
PRIORITY int 10
STATE varchar 16
JOB_NAME varchar 200  √  null
JOB_GROUP varchar 200  √  null
REQUESTS_RECOVERY varchar 1  √  null
is_nonconcurrent bit 0  √  null
is_update_data bit 0  √  null
SCHED_NAME varchar 120 unifiedManagerScheduler
SCHED_TIME bigint 19

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

Indexes:
Column(s) Type Sort Constraint Name
SCHED_NAME + ENTRY_ID Primary key Asc/Asc PRIMARY
SCHED_NAME + INSTANCE_NAME + REQUESTS_RECOVERY Performance Asc/Asc/Asc idx_qrtz_ft_inst_job_req_rcvry
SCHED_NAME + JOB_NAME + JOB_GROUP Performance Asc/Asc/Asc idx_qrtz_ft_j_g
SCHED_NAME + JOB_GROUP Performance Asc/Asc idx_qrtz_ft_jg
SCHED_NAME + TRIGGER_NAME + TRIGGER_GROUP Performance Asc/Asc/Asc idx_qrtz_ft_t_g
SCHED_NAME + TRIGGER_GROUP Performance Asc/Asc idx_qrtz_ft_tg
SCHED_NAME + INSTANCE_NAME Performance Asc/Asc idx_qrtz_ft_trig_inst_name