Table ocum.qrtz_simprop_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
SCHED_NAME varchar 120
qrtz_triggers.SCHED_NAME qrtz_simprop_triggers_ibfk_1 R
TRIGGER_NAME varchar 200
qrtz_triggers.TRIGGER_NAME qrtz_simprop_triggers_ibfk_1 R
TRIGGER_GROUP varchar 200
qrtz_triggers.TRIGGER_GROUP qrtz_simprop_triggers_ibfk_1 R
STR_PROP_1 varchar 512  √  null
STR_PROP_2 varchar 512  √  null
STR_PROP_3 varchar 512  √  null
INT_PROP_1 int 10  √  null
INT_PROP_2 int 10  √  null
LONG_PROP_1 bigint 19  √  null
LONG_PROP_2 bigint 19  √  null
DEC_PROP_1 decimal 13,4  √  null
DEC_PROP_2 decimal 13,4  √  null
BOOL_PROP_1 bit 0  √  null
BOOL_PROP_2 bit 0  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
SCHED_NAME + TRIGGER_NAME + TRIGGER_GROUP Primary key Asc/Asc/Asc PRIMARY

Close relationships  within of separation: