Difference between revisions of "IX.ORDERS QUEUETABLE (table)"

From dbscript Online Help
Jump to: navigation, search
 
(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
 
| IX.ORDERS_QUEUETABLE
 
| IX.ORDERS_QUEUETABLE
−
|-
 
 
|}
 
|}
  
−
 
+
=== 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"
−
|-
 
 
| Q_NAME
 
| Q_NAME
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 24: Line 22:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| MSGID
 
| MSGID
 
| RAW(16)
 
| RAW(16)
 
| not null
 
| not null
 
|  
 
|  
−
| SYS_C005059
 
 
|  
 
|  
−
|-
+
|- valign="top"
 
| CORRID
 
| CORRID
 
| VARCHAR2(128)
 
| VARCHAR2(128)
Line 38: Line 34:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| PRIORITY
 
| PRIORITY
 
| NUMBER
 
| NUMBER
Line 45: Line 40:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| STATE
 
| STATE
 
| NUMBER
 
| NUMBER
Line 52: Line 46:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| DELAY
 
| DELAY
 
| TIMESTAMP(6)
 
| TIMESTAMP(6)
Line 59: Line 52:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| EXPIRATION
 
| EXPIRATION
 
| NUMBER
 
| NUMBER
Line 66: Line 58:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| TIME_MANAGER_INFO
 
| TIME_MANAGER_INFO
 
| TIMESTAMP(6)
 
| TIMESTAMP(6)
Line 73: Line 64:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| LOCAL_ORDER_NO
 
| LOCAL_ORDER_NO
 
| NUMBER
 
| NUMBER
Line 80: Line 70:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| CHAIN_NO
 
| CHAIN_NO
 
| NUMBER
 
| NUMBER
Line 87: Line 76:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| CSCN
 
| CSCN
 
| NUMBER
 
| NUMBER
Line 94: Line 82:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| DSCN
 
| DSCN
 
| NUMBER
 
| NUMBER
Line 101: Line 88:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| ENQ_TIME
 
| ENQ_TIME
 
| TIMESTAMP(6)
 
| TIMESTAMP(6)
Line 108: Line 94:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| ENQ_UID
 
| ENQ_UID
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 115: Line 100:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| ENQ_TID
 
| ENQ_TID
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 122: Line 106:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| DEQ_TIME
 
| DEQ_TIME
 
| TIMESTAMP(6)
 
| TIMESTAMP(6)
Line 129: Line 112:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| DEQ_UID
 
| DEQ_UID
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 136: Line 118:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| DEQ_TID
 
| DEQ_TID
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 143: Line 124:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| RETRY_COUNT
 
| RETRY_COUNT
 
| NUMBER
 
| NUMBER
Line 150: Line 130:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| EXCEPTION_QSCHEMA
 
| EXCEPTION_QSCHEMA
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 157: Line 136:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| EXCEPTION_QUEUE
 
| EXCEPTION_QUEUE
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 164: Line 142:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| STEP_NO
 
| STEP_NO
 
| NUMBER
 
| NUMBER
Line 171: Line 148:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| RECIPIENT_KEY
 
| RECIPIENT_KEY
 
| NUMBER
 
| NUMBER
Line 178: Line 154:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| DEQUEUE_MSGID
 
| DEQUEUE_MSGID
 
| RAW(16)
 
| RAW(16)
Line 185: Line 160:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| SENDER_NAME
 
| SENDER_NAME
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 192: Line 166:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| SENDER_ADDRESS
 
| SENDER_ADDRESS
 
| VARCHAR2(1024)
 
| VARCHAR2(1024)
Line 199: Line 172:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| SENDER_PROTOCOL
 
| SENDER_PROTOCOL
 
| NUMBER
 
| NUMBER
Line 206: Line 178:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| USER_DATA
 
| USER_DATA
 
| IX.ORDER_EVENT_TYP
 
| IX.ORDER_EVENT_TYP
Line 213: Line 184:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| USER_PROP
 
| USER_PROP
 
| SYS.ANYDATA
 
| SYS.ANYDATA
Line 220: Line 190:
 
|  
 
|  
 
|  
 
|  
−
|  
+
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| SYS_C005059
 +
| MSGID
 
|}
 
|}

Latest revision as of 11:34, 27 August 2011

wikibot[edit]

Table IX.ORDERS_QUEUETABLE

Columns[edit]

Column Data Type Nullable Default Description
Q_NAME VARCHAR2(30) null
MSGID RAW(16) not null
CORRID VARCHAR2(128) null
PRIORITY NUMBER null
STATE NUMBER null
DELAY TIMESTAMP(6) null
EXPIRATION NUMBER null
TIME_MANAGER_INFO TIMESTAMP(6) null
LOCAL_ORDER_NO NUMBER null
CHAIN_NO NUMBER null
CSCN NUMBER null
DSCN NUMBER null
ENQ_TIME TIMESTAMP(6) null
ENQ_UID VARCHAR2(30) null
ENQ_TID VARCHAR2(30) null
DEQ_TIME TIMESTAMP(6) null
DEQ_UID VARCHAR2(30) null
DEQ_TID VARCHAR2(30) null
RETRY_COUNT NUMBER null
EXCEPTION_QSCHEMA VARCHAR2(30) null
EXCEPTION_QUEUE VARCHAR2(30) null
STEP_NO NUMBER null
RECIPIENT_KEY NUMBER null
DEQUEUE_MSGID RAW(16) null
SENDER_NAME VARCHAR2(30) null
SENDER_ADDRESS VARCHAR2(1024) null
SENDER_PROTOCOL NUMBER null
USER_DATA IX.ORDER_EVENT_TYP null
USER_PROP SYS.ANYDATA null

Primary Key[edit]

Primary Key Columns
SYS_C005059 MSGID
Retrieved from "http://dbshelp.devio.at/index.php?title=IX.ORDERS_QUEUETABLE_(table)&oldid=3062"