Public.qrtz triggers (table)

From dbscript Online Help
Jump to: navigation, search

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]

Relation Column Referenced Column
public.qrtz_job_details job_name job_name

Detail Tables[edit]

Detail Table Column Referencing Column
public.qrtz_blob_triggers trigger_name trigger_name
public.qrtz_blob_triggers trigger_name trigger_name
public.qrtz_cron_triggers trigger_name trigger_name
public.qrtz_cron_triggers trigger_name trigger_name
public.qrtz_simple_triggers trigger_name trigger_name
public.qrtz_simple_triggers trigger_name trigger_name
public.qrtz_trigger_listeners trigger_name trigger_name
public.qrtz_trigger_listeners trigger_name trigger_name