qrtz_simprop_triggers


Description

{“what”:“Holds typed property values for triggers that use simple properties in Quartz.”,“why”:“Without it, trigger-specific property values would be lost, breaking trigger recovery and execution.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:58.038856180+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
sched_name varchar 120 null
qrtz_triggers.sched_name fk_qrtz_simprop_triggers_triggers R

{“what”:“Scheduler instance name that owns the trigger; part of composite primary key.”,“why”:“Without it, triggers from different schedulers would collide, making property lookup ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:58.663430920+00:00”}
trigger_name varchar 200 null
qrtz_triggers.trigger_name fk_qrtz_simprop_triggers_triggers R

{“what”:“Trigger name within its group; part of composite primary key.”,“why”:“Without it, the trigger cannot be uniquely identified to fetch its properties.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:59.314509521+00:00”}
trigger_group varchar 200 null
qrtz_triggers.trigger_group fk_qrtz_simprop_triggers_triggers R

{“what”:“Trigger group name; part of composite primary key.”,“why”:“Without it, triggers with same name in different groups would be ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:59.365966067+00:00”}
str_prop_1 varchar 512 √ null

{“what”:“First string property value; semantics depend on the trigger’s configuration.”,“why”:“Without it, the trigger’s first string property is missing, altering its behavior.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:59.413434214+00:00”}
str_prop_2 varchar 512 √ null

{“what”:“Second string property value; semantics depend on the trigger’s configuration.”,“why”:“Without it, the trigger’s second string property is missing, altering its behavior.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:59.440117126+00:00”}
str_prop_3 varchar 512 √ null

{“what”:“Third string property value; semantics depend on the trigger’s configuration.”,“why”:“Without it, the trigger’s third string property is missing, altering its behavior.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:59.470721445+00:00”}
int_prop_1 int4 10 √ null

{“what”:“First integer property value; semantics depend on the trigger’s configuration.”,“why”:“Without it, the trigger’s first integer property is missing, altering its behavior.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:59.560037548+00:00”}
int_prop_2 int4 10 √ null

{“what”:“Second integer property value; semantics depend on the trigger’s configuration.”,“why”:“Without it, the trigger’s second integer property is missing, altering its behavior.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:59.654477686+00:00”}
long_prop_1 int8 19 √ null

{“what”:“First long integer property value; semantics depend on the trigger’s configuration.”,“why”:“Without it, the trigger’s first long property is missing, altering its behavior.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:59.737480882+00:00”}
long_prop_2 int8 19 √ null

{“what”:“Second long integer property value; semantics depend on the trigger’s configuration.”,“why”:“Without it, the trigger’s second long property is missing, altering its behavior.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:59.839070321+00:00”}
dec_prop_1 numeric 13,4 √ null

{“what”:“First decimal property value; semantics depend on the trigger’s configuration.”,“why”:“Without it, the trigger’s first decimal property is missing, altering its behavior.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:59.852955864+00:00”}
dec_prop_2 numeric 13,4 √ null

{“what”:“Second decimal property value; semantics depend on the trigger’s configuration.”,“why”:“Without it, the trigger’s second decimal property is missing, altering its behavior.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:59.887849792+00:00”}
bool_prop_1 bool 1 √ null

{“what”:“First boolean property value; semantics depend on the trigger’s configuration.”,“why”:“Without it, the trigger’s first boolean property is missing, altering its behavior.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:59.901902762+00:00”}
bool_prop_2 bool 1 √ null

{“what”:“Second boolean property value; semantics depend on the trigger’s configuration.”,“why”:“Without it, the trigger’s second boolean property is missing, altering its behavior.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:59.948211280+00:00”}

Indexes

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

Relationships

Close relationships within degrees of separation