Difference between revisions of "Public.qrtz simple 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_simple_triggers
 
| public.qrtz_simple_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"
 
| repeat_count
 
| repeat_count
 
| bigint
 
| bigint
Line 36: Line 34:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| repeat_interval
 
| repeat_interval
 
| bigint
 
| bigint
Line 42: Line 40:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| times_triggered
 
| times_triggered
 
| bigint
 
| bigint
Line 55: Line 53:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| pk_qrtz_simple_triggers
 
| pk_qrtz_simple_triggers
 
| trigger_name, trigger_group
 
| trigger_name, trigger_group
Line 66: Line 64:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
+
 
|-
+
|- valign="top"
 
| [[public.qrtz_triggers_(table)|public.qrtz_triggers]]
 
| [[public.qrtz_triggers_(table)|public.qrtz_triggers]]
 
| trigger_name
 
| trigger_name
 
| trigger_name
 
| trigger_name
 
|}
 
|}

Latest revision as of 23:39, 24 June 2010

wikibot[edit]

Table public.qrtz_simple_triggers

Columns[edit]

Column Data Type Nullable Default Description
trigger_name varchar(80) not null
trigger_group varchar(80) not null
repeat_count bigint not null
repeat_interval bigint not null
times_triggered bigint not null

Primary Key[edit]

Primary Key Columns
pk_qrtz_simple_triggers trigger_name, trigger_group

Foreign Keys[edit]

Relation Column Referenced Column
public.qrtz_triggers trigger_name trigger_name