Difference between revisions of "Public.qrtz triggers (table)"

From dbscript Online Help
Jump to: navigation, search
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| public.qrtz_triggers
 
| public.qrtz_triggers
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 17: Line 15:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| trigger_name
 
| trigger_name
 
| varchar(80)
 
| varchar(80)
Line 24: Line 22:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| trigger_group
 
| trigger_group
 
| varchar(80)
 
| varchar(80)
Line 30: Line 28:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| job_name
 
| job_name
 
| varchar(80)
 
| varchar(80)
Line 36: Line 34:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| job_group
 
| job_group
 
| varchar(80)
 
| varchar(80)
Line 42: Line 40:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| is_volatile
 
| is_volatile
 
| boolean
 
| boolean
Line 48: Line 46:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| description
 
| description
 
| varchar(120)
 
| varchar(120)
Line 54: Line 52:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| next_fire_time
 
| next_fire_time
 
| bigint
 
| bigint
Line 60: Line 58:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| prev_fire_time
 
| prev_fire_time
 
| bigint
 
| bigint
Line 66: Line 64:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| trigger_state
 
| trigger_state
 
| varchar(16)
 
| varchar(16)
Line 72: Line 70:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| trigger_type
 
| trigger_type
 
| varchar(8)
 
| varchar(8)
Line 78: Line 76:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| start_time
 
| start_time
 
| bigint
 
| bigint
Line 84: Line 82:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| end_time
 
| end_time
 
| bigint
 
| bigint
Line 90: Line 88:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| calendar_name
 
| calendar_name
 
| varchar(80)
 
| varchar(80)
Line 96: Line 94:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| misfire_instr
 
| misfire_instr
 
| smallint
 
| smallint
Line 102: Line 100:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| job_data
 
| job_data
 
| bytea
 
| bytea
Line 115: Line 113:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| pk_qrtz_triggers
 
| pk_qrtz_triggers
 
| trigger_name, trigger_group
 
| trigger_name, trigger_group
Line 126: Line 124:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
+
 
|-
+
|- valign="top"
 
| [[public.qrtz_job_details_(table)|public.qrtz_job_details]]
 
| [[public.qrtz_job_details_(table)|public.qrtz_job_details]]
 
| job_name
 
| job_name
Line 139: Line 137:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
+
 
|-
+
|- valign="top"
 
| [[public.qrtz_blob_triggers_(table)|public.qrtz_blob_triggers]]
 
| [[public.qrtz_blob_triggers_(table)|public.qrtz_blob_triggers]]
 
| trigger_name
 
| trigger_name
 
| trigger_name
 
| trigger_name
|-
+
|- valign="top"
 
| [[public.qrtz_blob_triggers_(table)|public.qrtz_blob_triggers]]
 
| [[public.qrtz_blob_triggers_(table)|public.qrtz_blob_triggers]]
 
| trigger_name
 
| trigger_name
 
| trigger_name
 
| trigger_name
|-
+
|- valign="top"
 
| [[public.qrtz_cron_triggers_(table)|public.qrtz_cron_triggers]]
 
| [[public.qrtz_cron_triggers_(table)|public.qrtz_cron_triggers]]
 
| trigger_name
 
| trigger_name
 
| trigger_name
 
| trigger_name
|-
+
|- valign="top"
 
| [[public.qrtz_cron_triggers_(table)|public.qrtz_cron_triggers]]
 
| [[public.qrtz_cron_triggers_(table)|public.qrtz_cron_triggers]]
 
| trigger_name
 
| trigger_name
 
| trigger_name
 
| trigger_name
|-
+
|- valign="top"
 
| [[public.qrtz_simple_triggers_(table)|public.qrtz_simple_triggers]]
 
| [[public.qrtz_simple_triggers_(table)|public.qrtz_simple_triggers]]
 
| trigger_name
 
| trigger_name
 
| trigger_name
 
| trigger_name
|-
+
|- valign="top"
 
| [[public.qrtz_simple_triggers_(table)|public.qrtz_simple_triggers]]
 
| [[public.qrtz_simple_triggers_(table)|public.qrtz_simple_triggers]]
 
| trigger_name
 
| trigger_name
 
| trigger_name
 
| trigger_name
|-
+
|- valign="top"
 
| [[public.qrtz_trigger_listeners_(table)|public.qrtz_trigger_listeners]]
 
| [[public.qrtz_trigger_listeners_(table)|public.qrtz_trigger_listeners]]
 
| trigger_name
 
| trigger_name
 
| trigger_name
 
| trigger_name
|-
+
|- valign="top"
 
| [[public.qrtz_trigger_listeners_(table)|public.qrtz_trigger_listeners]]
 
| [[public.qrtz_trigger_listeners_(table)|public.qrtz_trigger_listeners]]
 
| trigger_name
 
| trigger_name
 
| trigger_name
 
| trigger_name
 
|}
 
|}

Revision as of 23:39, 24 June 2010

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