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

From dbscript Online Help
Jump to: navigation, search
Line 9: Line 9:
  
  
 +
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 16:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
| '''PK
+
| '''Description
| '''Index
 
 
 
 
|-
 
|-
Line 23: Line 23:
 
| not null
 
| not null
 
|  
 
|  
| pk_qrtz_simple_triggers
 
 
|  
 
|  
 
|-
 
|-
Line 30: Line 29:
 
| not null
 
| not null
 
|  
 
|  
| pk_qrtz_simple_triggers
 
 
|  
 
|  
 
|-
 
|-
Line 36: Line 34:
 
| bigint
 
| bigint
 
| not null
 
| not null
|
 
 
|  
 
|  
 
|  
 
|  
Line 43: Line 40:
 
| bigint
 
| bigint
 
| not null
 
| not null
|
 
 
|  
 
|  
 
|  
 
|  
Line 50: Line 46:
 
| bigint
 
| bigint
 
| not null
 
| not null
|
 
 
|  
 
|  
 
|  
 
|  
 
|}
 
|}
  
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|-
 +
| pk_qrtz_simple_triggers
 +
| trigger_name, trigger_group
 +
|}
  
 
+
=== Foreign Keys ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"

Revision as of 09:32, 11 February 2010

wikibot

Table public.qrtz_simple_triggers


Columns

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

Primary Key Columns
pk_qrtz_simple_triggers trigger_name, trigger_group

Foreign Keys

Relation Column Referenced Column
public.qrtz_triggers trigger_name trigger_name