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

From dbscript Online Help
Jump to: navigation, search
 
(One intermediate revision 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.AQ$_ORDERS_QUEUETABLE_G
 
| IX.AQ$_ORDERS_QUEUETABLE_G
|-
 
 
|}
 
|}
  
 
+
=== 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"
|-
 
 
| MSGID
 
| MSGID
 
| RAW(16)
 
| RAW(16)
 
| not null
 
| not null
 
|  
 
|  
| SYS_IOT_TOP_49905
 
 
|  
 
|  
|-
+
|- valign="top"
 
| SUBSCRIBER#
 
| SUBSCRIBER#
 
| NUMBER
 
| NUMBER
 
| not null
 
| not null
 
|  
 
|  
| SYS_IOT_TOP_49905
 
 
|  
 
|  
|-
+
|- valign="top"
 
| NAME
 
| NAME
 
| VARCHAR2(30)
 
| VARCHAR2(30)
 
| not null
 
| not null
 
|  
 
|  
| SYS_IOT_TOP_49905
 
 
|  
 
|  
|-
+
|- valign="top"
 
| ADDRESS#
 
| ADDRESS#
 
| NUMBER
 
| NUMBER
 
| not null
 
| not null
 
|  
 
|  
| SYS_IOT_TOP_49905
 
 
|  
 
|  
|-
+
|- valign="top"
 
| SIGN
 
| SIGN
 
| SYS.AQ$_SIG_PROP
 
| SYS.AQ$_SIG_PROP
Line 52: Line 46:
 
|  
 
|  
 
|  
 
|  
|
+
|- valign="top"
|-
 
 
| DBS_SIGN
 
| DBS_SIGN
 
| SYS.AQ$_SIG_PROP
 
| SYS.AQ$_SIG_PROP
Line 59: Line 52:
 
|  
 
|  
 
|  
 
|  
|  
+
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| SYS_IOT_TOP_49905
 +
| MSGID, SUBSCRIBER#, NAME, ADDRESS#
 
|}
 
|}

Latest revision as of 06:14, 24 June 2010

wikibot[edit]

Table IX.AQ$_ORDERS_QUEUETABLE_G

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
SIGN SYS.AQ$_SIG_PROP null
DBS_SIGN SYS.AQ$_SIG_PROP null

Primary Key[edit]

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