qrtz_blob_triggers


Columns

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

{“what”:“Scheduler instance name; part of composite primary key.”,“why”:“Without it, triggers from different schedulers collide.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:30.002664370+00:00”}

trigger_name varchar 200 null
qrtz_triggers.trigger_name fk_qrtz_blob_triggers_triggers R

{“what”:“Trigger name within its group; part of composite primary key.”,“why”:“Without it, triggers in the same group cannot be distinguished.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:30.018942993+00:00”}

trigger_group varchar 200 null
qrtz_triggers.trigger_group fk_qrtz_blob_triggers_triggers R

{“what”:“Group name that categorizes triggers; part of composite primary key.”,“why”:“Without it, trigger names are not unique across groups.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:30.031447065+00:00”}

blob_data bytea 2147483647 √ null

{“what”:“Binary serialized trigger details; format depends on scheduler.”,“why”:“Without it, trigger data that relies on BLOB storage is unavailable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:30.060435061+00:00”}

Indexes

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

Relationships