Table candlepin.public.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 int8 19
priority int4 10
state varchar 16
job_name varchar 200  √  null
job_group varchar 200  √  null
requests_recovery bool 1  √  null
is_nonconcurrent bool 1  √  null
is_update_data bool 1  √  null
sched_name varchar 120 'TestScheduler'::character varying

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

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