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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.qrtz_fired_triggers |- |} {| border="1" cellpadding="5" cellspacing="...)
 
 
(2 intermediate revisions by the same user not shown)
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_fired_triggers
 
| public.qrtz_fired_triggers
|-
 
 
|}
 
|}
  
 
+
=== 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 14:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
| '''PK
+
| '''Description
| '''Index
+
 
+
|- valign="top"
|-
 
 
| entry_id
 
| entry_id
|  
+
| varchar(95)
 
| not null
 
| not null
 
|  
 
|  
| pk_qrtz_fired_triggers
 
 
|  
 
|  
|-
+
|- valign="top"
 
| trigger_name
 
| trigger_name
|  
+
| varchar(80)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
|
+
|- valign="top"
|-
 
 
| trigger_group
 
| trigger_group
|  
+
| varchar(80)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
|
+
|- valign="top"
|-
 
 
| is_volatile
 
| is_volatile
|  
+
| boolean
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
|
+
|- valign="top"
|-
 
 
| instance_name
 
| instance_name
|  
+
| varchar(80)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
|
+
|- valign="top"
|-
 
 
| fired_time
 
| fired_time
|  
+
| bigint
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
|
+
|- valign="top"
|-
 
 
| state
 
| state
|  
+
| varchar(16)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
|
+
|- valign="top"
|-
 
 
| job_name
 
| job_name
|  
+
| varchar(80)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
|
+
|- valign="top"
|-
 
 
| job_group
 
| job_group
|  
+
| varchar(80)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
|
+
|- valign="top"
|-
 
 
| is_stateful
 
| is_stateful
|  
+
| boolean
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
|
+
|- valign="top"
|-
 
 
| requests_recovery
 
| requests_recovery
|  
+
| boolean
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
|  
+
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| pk_qrtz_fired_triggers
 +
| entry_id
 
|}
 
|}

Latest revision as of 00:39, 25 June 2010

wikibot[edit]

Table public.qrtz_fired_triggers

Columns[edit]

Column Data Type Nullable Default Description
entry_id varchar(95) not null
trigger_name varchar(80) not null
trigger_group varchar(80) not null
is_volatile boolean not null
instance_name varchar(80) not null
fired_time bigint not null
state varchar(16) not null
job_name varchar(80) null
job_group varchar(80) null
is_stateful boolean null
requests_recovery boolean null

Primary Key[edit]

Primary Key Columns
pk_qrtz_fired_triggers entry_id