Table oc312.public.oc_qrtz_triggers Generated by
SchemaSpy
Legend:
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
oc_qrtz_blob_triggers.trigger_name oc_qrtz_blob_triggers_trg_fkey R
oc_qrtz_cron_triggers.trigger_name oc_qrtz_cron_triggers_trg_fkey R
oc_qrtz_simple_triggers.trigger_name oc_qrtz_simple_trigs_trg_fkey R
oc_qrtz_trigger_listeners.trigger_name oc_qrtz_trigger_lsnrs_trg_fkey R
trigger_group varchar 200
oc_qrtz_blob_triggers.trigger_group oc_qrtz_blob_triggers_trg_fkey R
oc_qrtz_cron_triggers.trigger_group oc_qrtz_cron_triggers_trg_fkey R
oc_qrtz_simple_triggers.trigger_group oc_qrtz_simple_trigs_trg_fkey R
oc_qrtz_trigger_listeners.trigger_group oc_qrtz_trigger_lsnrs_trg_fkey R
oc_qrtz_paused_trigger_grps.trigger_group Implied Constraint R
job_name varchar 200
oc_qrtz_job_details.job_name oc_qrtz_triggers_job_name_fkey R
job_group varchar 200
oc_qrtz_job_details.job_group oc_qrtz_triggers_job_name_fkey R
is_volatile bool 1
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
oc_qrtz_calendars.calendar_name Implied Constraint R
misfire_instr int2 5  √  null
job_data bytea 2147483647  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
trigger_name + trigger_group Primary key Asc/Asc pk_oc_qrtz_triggers

Close relationships  within of separation: