Table oc312.public.oc_qrtz_job_details 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
job_name varchar 200
oc_qrtz_job_listeners.job_name oc_qrtz_job_listeners_job_fkey R
oc_qrtz_triggers.job_name oc_qrtz_triggers_job_name_fkey R
job_group varchar 200
oc_qrtz_job_listeners.job_group oc_qrtz_job_listeners_job_fkey R
oc_qrtz_triggers.job_group oc_qrtz_triggers_job_name_fkey R
description varchar 250  √  null
job_class_name varchar 250
is_durable bool 1
is_volatile bool 1
is_stateful bool 1
requests_recovery bool 1
job_data bytea 2147483647  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
job_name + job_group Primary key Asc/Asc pk_oc_qrtz_job_details

Close relationships  within of separation: