Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

Tablepublic.qrtz_triggers

Columns

ColumnData TypeNullableDefaultDescription
trigger_namevarchar(80)not null  
trigger_groupvarchar(80)not null  
job_namevarchar(80)not null  
job_groupvarchar(80)not null  
is_volatilebooleannot null  
descriptionvarchar(120)null  
next_fire_timebigintnull  
prev_fire_timebigintnull  
trigger_statevarchar(16)not null  
trigger_typevarchar(8)not null  
start_timebigintnot null  
end_timebigintnull  
calendar_namevarchar(80)null  
misfire_instrsmallintnull  
job_databyteanull  

Primary Key

Primary KeyColumns
pk_qrtz_triggerstrigger_name, trigger_group

Foreign Keys

RelationColumnReferenced Column
public.qrtz_job_detailsjob_namejob_name

Detail Tables

Detail TableColumnReferencing Column
public.qrtz_blob_triggerstrigger_nametrigger_name
public.qrtz_blob_triggerstrigger_nametrigger_name
public.qrtz_cron_triggerstrigger_nametrigger_name
public.qrtz_cron_triggerstrigger_nametrigger_name
public.qrtz_simple_triggerstrigger_nametrigger_name
public.qrtz_simple_triggerstrigger_nametrigger_name
public.qrtz_trigger_listenerstrigger_nametrigger_name
public.qrtz_trigger_listenerstrigger_nametrigger_name

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.