Difference between revisions of "IX.ORDERS QUEUETABLE (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
 
| IX.ORDERS_QUEUETABLE
 
| IX.ORDERS_QUEUETABLE
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 17: Line 15:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| Q_NAME
 
| Q_NAME
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 24: Line 22:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| MSGID
 
| MSGID
 
| RAW(16)
 
| RAW(16)
Line 30: Line 28:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| CORRID
 
| CORRID
 
| VARCHAR2(128)
 
| VARCHAR2(128)
Line 36: Line 34:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| PRIORITY
 
| PRIORITY
 
| NUMBER
 
| NUMBER
Line 42: Line 40:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| STATE
 
| STATE
 
| NUMBER
 
| NUMBER
Line 48: Line 46:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| DELAY
 
| DELAY
 
| TIMESTAMP(6)
 
| TIMESTAMP(6)
Line 54: Line 52:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| EXPIRATION
 
| EXPIRATION
 
| NUMBER
 
| NUMBER
Line 60: Line 58:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| TIME_MANAGER_INFO
 
| TIME_MANAGER_INFO
 
| TIMESTAMP(6)
 
| TIMESTAMP(6)
Line 66: Line 64:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| LOCAL_ORDER_NO
 
| LOCAL_ORDER_NO
 
| NUMBER
 
| NUMBER
Line 72: Line 70:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| CHAIN_NO
 
| CHAIN_NO
 
| NUMBER
 
| NUMBER
Line 78: Line 76:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| CSCN
 
| CSCN
 
| NUMBER
 
| NUMBER
Line 84: Line 82:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| DSCN
 
| DSCN
 
| NUMBER
 
| NUMBER
Line 90: Line 88:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| ENQ_TIME
 
| ENQ_TIME
 
| TIMESTAMP(6)
 
| TIMESTAMP(6)
Line 96: Line 94:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| ENQ_UID
 
| ENQ_UID
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 102: Line 100:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| ENQ_TID
 
| ENQ_TID
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 108: Line 106:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| DEQ_TIME
 
| DEQ_TIME
 
| TIMESTAMP(6)
 
| TIMESTAMP(6)
Line 114: Line 112:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| DEQ_UID
 
| DEQ_UID
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 120: Line 118:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| DEQ_TID
 
| DEQ_TID
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 126: Line 124:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| RETRY_COUNT
 
| RETRY_COUNT
 
| NUMBER
 
| NUMBER
Line 132: Line 130:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| EXCEPTION_QSCHEMA
 
| EXCEPTION_QSCHEMA
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 138: Line 136:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| EXCEPTION_QUEUE
 
| EXCEPTION_QUEUE
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 144: Line 142:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| STEP_NO
 
| STEP_NO
 
| NUMBER
 
| NUMBER
Line 150: Line 148:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| RECIPIENT_KEY
 
| RECIPIENT_KEY
 
| NUMBER
 
| NUMBER
Line 156: Line 154:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| DEQUEUE_MSGID
 
| DEQUEUE_MSGID
 
| RAW(16)
 
| RAW(16)
Line 162: Line 160:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| SENDER_NAME
 
| SENDER_NAME
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 168: Line 166:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| SENDER_ADDRESS
 
| SENDER_ADDRESS
 
| VARCHAR2(1024)
 
| VARCHAR2(1024)
Line 174: Line 172:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| SENDER_PROTOCOL
 
| SENDER_PROTOCOL
 
| NUMBER
 
| NUMBER
Line 180: Line 178:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| USER_DATA
 
| USER_DATA
 
| IX.ORDER_EVENT_TYP
 
| IX.ORDER_EVENT_TYP
Line 186: Line 184:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| USER_PROP
 
| USER_PROP
 
| SYS.ANYDATA
 
| SYS.ANYDATA
Line 199: Line 197:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| SYS_C005059
 
| SYS_C005059
 
| MSGID
 
| MSGID
Line 211: Line 209:
 
| '''Referenced Object
 
| '''Referenced Object
  
|-
+
|- valign="top"
 
| Data Type
 
| Data Type
 
| Type
 
| Type

Revision as of 06:14, 24 June 2010

wikibot

Table IX.ORDERS_QUEUETABLE

Columns

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

Primary Key Columns
SYS_C005059 MSGID

References

Dependency Type Object Type Referenced Object
Data Type Type IX.ORDER_EVENT_TYP