Difference between revisions of "IX.AQ$ ORDERS QUEUETABLE H (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.AQ$_ORDERS_QUEUETABLE_H
 
| IX.AQ$_ORDERS_QUEUETABLE_H
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 17: Line 15:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| MSGID
 
| MSGID
 
| RAW(16)
 
| RAW(16)
Line 24: Line 22:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| SUBSCRIBER#
 
| SUBSCRIBER#
 
| NUMBER
 
| NUMBER
Line 30: Line 28:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| NAME
 
| NAME
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 36: Line 34:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| ADDRESS#
 
| ADDRESS#
 
| NUMBER
 
| NUMBER
Line 42: Line 40:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| DEQUEUE_TIME
 
| DEQUEUE_TIME
 
| TIMESTAMP(6)
 
| TIMESTAMP(6)
Line 48: Line 46:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| TRANSACTION_ID
 
| TRANSACTION_ID
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 54: Line 52:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| DEQUEUE_USER
 
| DEQUEUE_USER
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 60: Line 58:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| PROPAGATED_MSGID
 
| PROPAGATED_MSGID
 
| RAW(16)
 
| RAW(16)
Line 66: Line 64:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| RETRY_COUNT
 
| RETRY_COUNT
 
| NUMBER
 
| NUMBER
Line 72: Line 70:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| HINT
 
| HINT
 
| ROWID
 
| ROWID
Line 78: Line 76:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| SPARE
 
| SPARE
 
| RAW(16)
 
| RAW(16)
Line 91: Line 89:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| SYS_IOT_TOP_49903
 
| SYS_IOT_TOP_49903
 
| MSGID, SUBSCRIBER#, NAME, ADDRESS#
 
| MSGID, SUBSCRIBER#, NAME, ADDRESS#
 
|}
 
|}

Latest revision as of 06:14, 24 June 2010

wikibot[edit]

Table IX.AQ$_ORDERS_QUEUETABLE_H

Columns[edit]

Column Data Type Nullable Default Description
MSGID RAW(16) not null
SUBSCRIBER# NUMBER not null
NAME VARCHAR2(30) not null
ADDRESS# NUMBER not null
DEQUEUE_TIME TIMESTAMP(6) null
TRANSACTION_ID VARCHAR2(30) null
DEQUEUE_USER VARCHAR2(30) null
PROPAGATED_MSGID RAW(16) null
RETRY_COUNT NUMBER null
HINT ROWID null
SPARE RAW(16) null

Primary Key[edit]

Primary Key Columns
SYS_IOT_TOP_49903 MSGID, SUBSCRIBER#, NAME, ADDRESS#