Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| sched_name | varchar | 120 | null |
|
|
{“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 |
|
|
{“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 |
|
|
{“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 |