From dbscript Online Help
wikibot[edit]
Table
|
public.qrtz_triggers
|
Columns[edit]
Column
|
Data Type
|
Nullable
|
Default
|
Description
|
trigger_name
|
varchar(80)
|
not null
|
|
|
trigger_group
|
varchar(80)
|
not null
|
|
|
job_name
|
varchar(80)
|
not null
|
|
|
job_group
|
varchar(80)
|
not null
|
|
|
is_volatile
|
boolean
|
not null
|
|
|
description
|
varchar(120)
|
null
|
|
|
next_fire_time
|
bigint
|
null
|
|
|
prev_fire_time
|
bigint
|
null
|
|
|
trigger_state
|
varchar(16)
|
not null
|
|
|
trigger_type
|
varchar(8)
|
not null
|
|
|
start_time
|
bigint
|
not null
|
|
|
end_time
|
bigint
|
null
|
|
|
calendar_name
|
varchar(80)
|
null
|
|
|
misfire_instr
|
smallint
|
null
|
|
|
job_data
|
bytea
|
null
|
|
|
Primary Key[edit]
Primary Key
|
Columns
|
pk_qrtz_triggers
|
trigger_name, trigger_group
|
Foreign Keys[edit]
Detail Tables[edit]