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

From dbscript Online Help
Jump to: navigation, search
Line 9: Line 9:
  
  
 +
=== 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 16:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
| '''PK
+
| '''Description
| '''Index
 
 
 
 
|-
 
|-
Line 23: Line 23:
 
| not null
 
| not null
 
|  
 
|  
| SYS_IOT_TOP_49908
 
 
|  
 
|  
 
|-
 
|-
Line 30: Line 29:
 
| not null
 
| not null
 
|  
 
|  
| SYS_IOT_TOP_49908
 
 
|  
 
|  
 
|-
 
|-
Line 37: Line 35:
 
| not null
 
| not null
 
|  
 
|  
| SYS_IOT_TOP_49908
 
 
|  
 
|  
 
|-
 
|-
Line 44: Line 41:
 
| not null
 
| not null
 
|  
 
|  
| SYS_IOT_TOP_49908
 
 
|  
 
|  
 
|-
 
|-
Line 51: Line 47:
 
| not null
 
| not null
 
|  
 
|  
| SYS_IOT_TOP_49908
 
 
|  
 
|  
 
|-
 
|-
Line 58: Line 53:
 
| not null
 
| not null
 
|  
 
|  
| SYS_IOT_TOP_49908
 
 
|  
 
|  
 
|-
 
|-
Line 65: Line 59:
 
| not null
 
| not null
 
|  
 
|  
| SYS_IOT_TOP_49908
 
 
|  
 
|  
 
|-
 
|-
Line 72: Line 65:
 
| not null
 
| not null
 
|  
 
|  
| SYS_IOT_TOP_49908
 
 
|  
 
|  
 
|-
 
|-
Line 78: Line 70:
 
| ROWID
 
| ROWID
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 87: Line 78:
 
|  
 
|  
 
|  
 
|  
|  
+
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|-
 +
| SYS_IOT_TOP_49908
 +
| SUBSCRIBER#, NAME, QUEUE#, MSG_ENQ_TIME, MSG_STEP_NO, MSG_CHAIN_NO, MSG_LOCAL_ORDER_NO, MSGID
 
|}
 
|}

Revision as of 08:27, 11 February 2010

wikibot

Table IX.AQ$_ORDERS_QUEUETABLE_I


Columns

Column Data Type Nullable Default Description
SUBSCRIBER# NUMBER not null
NAME VARCHAR2(30) not null
QUEUE# NUMBER not null
MSG_ENQ_TIME TIMESTAMP(6) not null
MSG_STEP_NO NUMBER not null
MSG_CHAIN_NO NUMBER not null
MSG_LOCAL_ORDER_NO NUMBER not null
MSGID RAW(16) not null
HINT ROWID null
SPARE RAW(16) null

Primary Key

Primary Key Columns
SYS_IOT_TOP_49908 SUBSCRIBER#, NAME, QUEUE#, MSG_ENQ_TIME, MSG_STEP_NO, MSG_CHAIN_NO, MSG_LOCAL_ORDER_NO, MSGID