From dbscript Online Help
wikibot
| Table
|
public.qrtz_triggers
|
Columns
| 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
| Primary Key
|
Columns
|
| pk_qrtz_triggers
|
trigger_name, trigger_group
|
Foreign Keys
Detail Tables