qrtz_simple_triggers.md
1.14 KB
qrtz_simple_triggers
存储简单的Trigger,包括重复次数,间隔以及已触发的次数。
- Rows (estimated): 0
- Data size: 16.0 KB
- Engine: InnoDB
- Collation: utf8mb3_general_ci
- Created: 2026-04-27 18:55:02
- Updated:
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 | REPEAT_COUNT |
bigint |
NO | 重复的次数统计 | |||
| 5 | REPEAT_INTERVAL |
bigint |
NO | 重复的间隔时间 | |||
| 6 | TIMES_TRIGGERED |
bigint |
NO | 已经触发的次数 |
Indexes
| Name | Unique | Type | Columns |
|---|---|---|---|
PRIMARY |
✓ | 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.