From dbscript Online Help
|
|
| (One intermediate revision by the same user not shown) |
(No difference)
|
Latest revision as of 10:25, 27 August 2011
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]
