qrtz_blob_triggers.md 1.06 KB

qrtz_blob_triggers

Trigger 作为 Blob 类型存储(用于 Quartz 用户用 JDBC 创建他们自己定制的 Trigger 类型,JobStore 并不知道如何存储实例的时候)

  • Engine: InnoDB
  • Collation: utf8mb3_general_ci

Columns

# Name Type Null Key Default Extra Comment
1 SCHED_NAME varchar(120) NO PRI 调度名称
2 TRIGGER_NAME varchar(200) NO PRI qrtz_triggers表trigger_name的外键
3 TRIGGER_GROUP varchar(200) NO PRI qrtz_triggers表trigger_group的外键
4 BLOB_DATA blob YES 一个blob字段,存放持久化Trigger对象

Indexes

Name Unique Type Columns
PRIMARY BTREE SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP
SCHED_NAME BTREE SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP

Narrative

No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.