Public.qrtz triggers (table)

From dbscript Online Help
Revision as of 15:44, 7 August 2009 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

Table public.qrtz_triggers


Column Data Type Nullable Default PK Index
trigger_name varchar(80) not null pk_qrtz_triggers
trigger_group varchar(80) not null pk_qrtz_triggers
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


Relation Column Referenced Column
public.qrtz_job_details job_name job_name


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