Welcome Guest, you are in: • Login

devio dbscript ScrewTurn Wiki

Navigation¶

Main Page

Create Account

Search the wiki
»

PoweredBy

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

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