Table candlepin.public.qrtz_job_details Generated by
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
job_name varchar 200
qrtz_triggers.job_name qrtz_triggers_job_name_fkey
job_group varchar 200
qrtz_triggers.job_group qrtz_triggers_job_name_fkey
description varchar 250  √  null
job_class_name varchar 250
is_durable bool 1
requests_recovery bool 1
job_data bytea 2147483647  √  null
is_nonconcurrent bool 1  √  null
is_update_data bool 1  √  null
sched_name varchar 120 'TestScheduler'::character varying
qrtz_triggers.sched_name qrtz_triggers_job_name_fkey

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

Column(s) Type Sort Constraint Name
sched_name + job_name + job_group Primary key Asc/Asc/Asc qrtz_job_details_pkey
sched_name + job_group Performance Asc/Asc idx_qrtz_j_grp
sched_name + requests_recovery Performance Asc/Asc idx_qrtz_j_req_recovery

Close relationships  within of separation: