Difference between revisions of "IX.AQ$ ORDERS QUEUETABLE S (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_C005062
 
 
|  
 
|  
 
|-
 
|-
Line 29: Line 28:
 
| VARCHAR2(30)
 
| VARCHAR2(30)
 
| not null
 
| not null
|
 
 
|  
 
|  
 
|  
 
|  
Line 36: Line 34:
 
| VARCHAR2(30)
 
| VARCHAR2(30)
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 43: Line 40:
 
| VARCHAR2(1024)
 
| VARCHAR2(1024)
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 50: Line 46:
 
| NUMBER
 
| NUMBER
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 57: Line 52:
 
| NUMBER
 
| NUMBER
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 64: Line 58:
 
| VARCHAR2(30)
 
| VARCHAR2(30)
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 71: Line 64:
 
| VARCHAR2(61)
 
| VARCHAR2(61)
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 78: Line 70:
 
| VARCHAR2(65)
 
| VARCHAR2(65)
 
| 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_C005062
 +
| SUBSCRIBER_ID
 +
|}
 +
 +
=== Check Constraints ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Check Constraint
 +
| '''Expression
 +
| '''Description
 +
 +
|-
 +
| SYS_C005060
 +
| "SUBSCRIBER_ID" IS NOT NULL
 +
|
 +
|-
 +
| SYS_C005061
 +
| "QUEUE_NAME" IS NOT NULL
 
|  
 
|  
 +
|}
 +
 +
=== Dependencies ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|-
 +
| Select
 +
| View
 +
| [[IX.AQ$ORDERS_QUEUETABLE_R_(view)|IX.AQ$ORDERS_QUEUETABLE_R]]
 +
 +
|-
 +
| Select
 +
| View
 +
| [[IX.AQ$ORDERS_QUEUETABLE_S_(view)|IX.AQ$ORDERS_QUEUETABLE_S]]
 +
 
|}
 
|}

Revision as of 08:27, 11 February 2010

wikibot

Table IX.AQ$_ORDERS_QUEUETABLE_S


Columns

Column Data Type Nullable Default Description
SUBSCRIBER_ID NUMBER not null
QUEUE_NAME VARCHAR2(30) not null
NAME VARCHAR2(30) null
ADDRESS VARCHAR2(1024) null
PROTOCOL NUMBER null
SUBSCRIBER_TYPE NUMBER null
RULE_NAME VARCHAR2(30) null
TRANS_NAME VARCHAR2(61) null
RULESET_NAME VARCHAR2(65) null
NEGATIVE_RULESET_NAME VARCHAR2(65) null

Primary Key

Primary Key Columns
SYS_C005062 SUBSCRIBER_ID

Check Constraints

Check Constraint Expression Description
SYS_C005060 "SUBSCRIBER_ID" IS NOT NULL
SYS_C005061 "QUEUE_NAME" IS NOT NULL

Dependencies

Reference Type Object Type Referencing Object
Select View IX.AQ$ORDERS_QUEUETABLE_R
Select View IX.AQ$ORDERS_QUEUETABLE_S