Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sched_name | varchar | 120 | null |
|
|
|||||||||||||
trigger_name | varchar | 200 | null |
|
|
|||||||||||||
trigger_group | varchar | 200 | null |
|
|
|||||||||||||
job_name | varchar | 200 | null |
|
|
|||||||||||||
job_group | varchar | 200 | null |
|
|
|||||||||||||
description | varchar | 250 | √ | null |
|
|
||||||||||||
next_fire_time | int8 | 19 | √ | null |
|
|
||||||||||||
prev_fire_time | int8 | 19 | √ | null |
|
|
||||||||||||
priority | int4 | 10 | √ | null |
|
|
||||||||||||
trigger_state | varchar | 16 | null |
|
|
|||||||||||||
trigger_type | varchar | 8 | null |
|
|
|||||||||||||
start_time | int8 | 19 | null |
|
|
|||||||||||||
end_time | int8 | 19 | √ | null |
|
|
||||||||||||
calendar_name | varchar | 200 | √ | null |
|
|
||||||||||||
misfire_instr | int2 | 5 | √ | null |
|
|
||||||||||||
job_data | bytea | 2147483647 | √ | null |
|
|
Table contained 2 rows
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
qrtz_triggers_pkey | Primary key | Asc/Asc/Asc | sched_name + trigger_name + trigger_group |
idx_qrtz_t_c | Performance | Asc/Asc | sched_name + calendar_name |
idx_qrtz_t_g | Performance | Asc/Asc | sched_name + trigger_group |
idx_qrtz_t_j | Performance | Asc/Asc/Asc | sched_name + job_name + job_group |
idx_qrtz_t_jg | Performance | Asc/Asc | sched_name + job_group |
idx_qrtz_t_n_g_state | Performance | Asc/Asc/Asc | sched_name + trigger_group + trigger_state |
idx_qrtz_t_n_state | Performance | Asc/Asc/Asc/Asc | sched_name + trigger_name + trigger_group + trigger_state |
idx_qrtz_t_next_fire_time | Performance | Asc/Asc | sched_name + next_fire_time |
idx_qrtz_t_nft_misfire | Performance | Asc/Asc/Asc | sched_name + misfire_instr + next_fire_time |
idx_qrtz_t_nft_st | Performance | Asc/Asc/Asc | sched_name + trigger_state + next_fire_time |
idx_qrtz_t_nft_st_misfire | Performance | Asc/Asc/Asc/Asc | sched_name + misfire_instr + next_fire_time + trigger_state |
idx_qrtz_t_nft_st_misfire_grp | Performance | Asc/Asc/Asc/Asc/Asc | sched_name + misfire_instr + next_fire_time + trigger_group + trigger_state |
idx_qrtz_t_state | Performance | Asc/Asc | sched_name + trigger_state |