Table candlepin.public.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_trigger_name_fkey
qrtz_cron_triggers.trigger_name qrtz_cron_triggers_trigger_name_fkey
qrtz_simple_triggers.trigger_name qrtz_simple_triggers_trigger_name_fkey
qrtz_simprop_triggers.trigger_name qrtz_simprop_triggers_trigger_name_fkey
trigger_group varchar 200
qrtz_blob_triggers.trigger_group qrtz_blob_triggers_trigger_name_fkey
qrtz_cron_triggers.trigger_group qrtz_cron_triggers_trigger_name_fkey
qrtz_simple_triggers.trigger_group qrtz_simple_triggers_trigger_name_fkey
qrtz_simprop_triggers.trigger_group qrtz_simprop_triggers_trigger_name_fkey
job_name varchar 200
qrtz_job_details.job_name qrtz_triggers_job_name_fkey
job_group varchar 200
qrtz_job_details.job_group qrtz_triggers_job_name_fkey
description varchar 250  √  null
next_fire_time int8 19  √  null
prev_fire_time int8 19  √  null
priority int4 10  √  null
trigger_state varchar 16
trigger_type varchar 8
start_time int8 19
end_time int8 19  √  null
calendar_name varchar 200  √  null
misfire_instr int2 5  √  null
job_data bytea 2147483647  √  null
sched_name varchar 120 'TestScheduler'::character varying
qrtz_blob_triggers.sched_name qrtz_blob_triggers_trigger_name_fkey
qrtz_cron_triggers.sched_name qrtz_cron_triggers_trigger_name_fkey
qrtz_simple_triggers.sched_name qrtz_simple_triggers_trigger_name_fkey
qrtz_simprop_triggers.sched_name qrtz_simprop_triggers_trigger_name_fkey
qrtz_job_details.sched_name qrtz_triggers_job_name_fkey

Table contained 0 rows at Mon Jan 14 11:12 EST 2013

Indexes:
Column(s) Type Sort Constraint Name
sched_name + trigger_name + trigger_group Primary key Asc/Asc/Asc qrtz_triggers_pkey
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

Close relationships: