Public.qrtz triggers (table)

From dbscript Online Help
Revision as of 23:39, 24 June 2010 by Bot (talk | contribs)
Jump to: navigation, search

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

Relation Column Referenced Column
public.qrtz_job_details job_name job_name

Detail Tables

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