From dbscript Online Help
wikibot
Table
|
IX.ORDERS_QUEUETABLE
|
Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
Q_NAME
|
VARCHAR2
|
null
|
|
|
|
MSGID
|
RAW
|
not null
|
|
SYS_C005059
|
|
CORRID
|
VARCHAR2
|
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
|
null
|
|
|
|
ENQ_TID
|
VARCHAR2
|
null
|
|
|
|
DEQ_TIME
|
TIMESTAMP(6)
|
null
|
|
|
|
DEQ_UID
|
VARCHAR2
|
null
|
|
|
|
DEQ_TID
|
VARCHAR2
|
null
|
|
|
|
RETRY_COUNT
|
NUMBER
|
null
|
|
|
|
EXCEPTION_QSCHEMA
|
VARCHAR2
|
null
|
|
|
|
EXCEPTION_QUEUE
|
VARCHAR2
|
null
|
|
|
|
STEP_NO
|
NUMBER
|
null
|
|
|
|
RECIPIENT_KEY
|
NUMBER
|
null
|
|
|
|
DEQUEUE_MSGID
|
RAW
|
null
|
|
|
|
SENDER_NAME
|
VARCHAR2
|
null
|
|
|
|
SENDER_ADDRESS
|
VARCHAR2
|
null
|
|
|
|
SENDER_PROTOCOL
|
NUMBER
|
null
|
|
|
|
USER_DATA
|
IX.ORDER_EVENT_TYP
|
null
|
|
|
|
USER_PROP
|
SYS.ANYDATA
|
null
|
|
|
|