Table candlepin.public.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_trigger_name_fkey
trigger_name varchar 200
qrtz_triggers.trigger_name qrtz_simprop_triggers_trigger_name_fkey
trigger_group varchar 200
qrtz_triggers.trigger_group qrtz_simprop_triggers_trigger_name_fkey
str_prop_1 varchar 512  √  null
str_prop_2 varchar 512  √  null
str_prop_3 varchar 512  √  null
int_prop_1 int4 10  √  null
int_prop_2 int4 10  √  null
long_prop_1 int8 19  √  null
long_prop_2 int8 19  √  null
dec_prop_1 numeric 13,4  √  null
dec_prop_2 numeric 13,4  √  null
bool_prop_1 bool 1  √  null
bool_prop_2 bool 1  √  null

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

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

Close relationships  within of separation: