qrtz_simple_triggers


Columns

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

{“what”:“Scheduler instance name that owns this trigger; part of composite key.”,“why”:“Without it, triggers from different schedulers would collide in the same table.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:50.652494803+00:00”}

trigger_name varchar 200 null
qrtz_triggers.trigger_name fk_qrtz_simple_triggers_triggers R

{“what”:“Unique trigger name within its group and scheduler; part of composite key.”,“why”:“Identifies which trigger these simple settings belong to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:50.668405809+00:00”}

trigger_group varchar 200 null
qrtz_triggers.trigger_group fk_qrtz_simple_triggers_triggers R

{“what”:“Group name that scopes the trigger name; part of composite key.”,“why”:“Allows same trigger name in different groups without ambiguity.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:50.694379640+00:00”}

repeat_count int8 19 null

{“what”:“Number of additional firings after the first.”,“why”:“Without it, the scheduler cannot determine when to stop repeating the trigger.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:50.706426060+00:00”}

repeat_interval int8 19 null

{“what”:“Milliseconds between successive firings.”,“why”:“Without it, the scheduler cannot compute when to fire next.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:50.717290642+00:00”}

times_triggered int8 19 null

{“what”:“Count of how many times this trigger has already fired.”,“why”:“Without it, the scheduler cannot know how many repeats remain or if the trigger is exhausted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:50.726719690+00:00”}

Indexes

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

Relationships