Table ocum.qrtz_job_details 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
JOB_NAME varchar 200
qrtz_triggers.JOB_NAME qrtz_triggers_ibfk_1 R
JOB_GROUP varchar 200
qrtz_triggers.JOB_GROUP qrtz_triggers_ibfk_1 R
DESCRIPTION varchar 250  √  null
JOB_CLASS_NAME varchar 250
IS_DURABLE varchar 1
REQUESTS_RECOVERY varchar 1
JOB_DATA blob 65535  √  null
is_nonconcurrent bit 0  √  null
is_update_data bit 0  √  null
SCHED_NAME varchar 120 unifiedManagerScheduler
qrtz_triggers.SCHED_NAME qrtz_triggers_ibfk_1 R

Table contained 5 rows at Tue Apr 23 05:29 EDT 2019

Indexes:
Column(s) Type Sort Constraint Name
SCHED_NAME + JOB_NAME + JOB_GROUP Primary key Asc/Asc/Asc PRIMARY
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: