qrtz_triggers

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
sched_name varchar 120 null
qrtz_blob_triggers.sched_name qrtz_blob_triggers_sched_name_fkey R
qrtz_cron_triggers.sched_name qrtz_cron_triggers_sched_name_fkey R
qrtz_simple_triggers.sched_name qrtz_simple_triggers_sched_name_fkey R
qrtz_simprop_triggers.sched_name qrtz_simprop_triggers_sched_name_fkey R
qrtz_job_details.sched_name qrtz_triggers_sched_name_fkey R
trigger_name varchar 200 null
qrtz_blob_triggers.trigger_name qrtz_blob_triggers_sched_name_fkey R
qrtz_cron_triggers.trigger_name qrtz_cron_triggers_sched_name_fkey R
qrtz_simple_triggers.trigger_name qrtz_simple_triggers_sched_name_fkey R
qrtz_simprop_triggers.trigger_name qrtz_simprop_triggers_sched_name_fkey R
trigger_group varchar 200 null
qrtz_blob_triggers.trigger_group qrtz_blob_triggers_sched_name_fkey R
qrtz_cron_triggers.trigger_group qrtz_cron_triggers_sched_name_fkey R
qrtz_simple_triggers.trigger_group qrtz_simple_triggers_sched_name_fkey R
qrtz_simprop_triggers.trigger_group qrtz_simprop_triggers_sched_name_fkey R
job_name varchar 200 null
qrtz_job_details.job_name qrtz_triggers_sched_name_fkey R
job_group varchar 200 null
qrtz_job_details.job_group qrtz_triggers_sched_name_fkey R
description varchar 250 √ null
next_fire_time int8 19 √ null
prev_fire_time int8 19 √ null
priority int4 10 √ null
trigger_state varchar 16 null
trigger_type varchar 8 null
start_time int8 19 null
end_time int8 19 √ null
calendar_name varchar 200 √ null
misfire_instr int2 5 √ null
job_data bytea 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
qrtz_triggers_pkey Primary key Asc/Asc/Asc sched_name + trigger_name + trigger_group
idx_qrtz_t_c Performance Asc/Asc sched_name + calendar_name
idx_qrtz_t_g Performance Asc/Asc sched_name + trigger_group
idx_qrtz_t_jg Performance Asc/Asc sched_name + job_group
idx_qrtz_t_n_g_state Performance Asc/Asc/Asc sched_name + trigger_group + trigger_state
idx_qrtz_t_n_state Performance Asc/Asc/Asc/Asc sched_name + trigger_name + trigger_group + trigger_state
idx_qrtz_t_next_fire_time Performance Asc/Asc sched_name + next_fire_time
idx_qrtz_t_nft_misfire Performance Asc/Asc/Asc sched_name + misfire_instr + next_fire_time
idx_qrtz_t_nft_st Performance Asc/Asc/Asc sched_name + trigger_state + next_fire_time
idx_qrtz_t_nft_st_misfire Performance Asc/Asc/Asc/Asc sched_name + misfire_instr + next_fire_time + trigger_state
idx_qrtz_t_nft_st_misfire_grp Performance Asc/Asc/Asc/Asc/Asc sched_name + misfire_instr + next_fire_time + trigger_group + trigger_state
idx_qrtz_t_state Performance Asc/Asc sched_name + trigger_state

Relationships

Close relationships within degrees of separation