Difference between revisions of "IX.AQ$ STREAMS QUEUE TABLE S (table)"

From dbscript Online Help
Jump to: navigation, search
 
(3 intermediate revisions 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$_STREAMS_QUEUE_TABLE_S
 
| IX.AQ$_STREAMS_QUEUE_TABLE_S
−
|-
+
|}
 +
 
 +
=== Columns ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description
 +
 
 +
|- valign="top"
 +
| SUBSCRIBER_ID
 +
| NUMBER
 +
| not null
 +
|
 +
|
 +
|- valign="top"
 +
| QUEUE_NAME
 +
| VARCHAR2(30)
 +
| not null
 +
|
 +
|
 +
|- valign="top"
 +
| NAME
 +
| VARCHAR2(30)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| ADDRESS
 +
| VARCHAR2(1024)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| PROTOCOL
 +
| NUMBER
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| SUBSCRIBER_TYPE
 +
| NUMBER
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| RULE_NAME
 +
| VARCHAR2(30)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| TRANS_NAME
 +
| VARCHAR2(61)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| RULESET_NAME
 +
| VARCHAR2(65)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| NEGATIVE_RULESET_NAME
 +
| VARCHAR2(65)
 +
| null
 +
|
 +
|
 +
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| SYS_C005070
 +
| SUBSCRIBER_ID
 +
|}
 +
 
 +
=== Check Constraints ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Check Constraint
 +
| '''Expression
 +
| '''Description
 +
 
 +
|- valign="top"
 +
| SYS_C005068
 +
| "SUBSCRIBER_ID" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| SYS_C005069
 +
| "QUEUE_NAME" IS NOT NULL
 +
|
 
|}
 
|}

Latest revision as of 10:34, 27 August 2011

wikibot[edit]

Table IX.AQ$_STREAMS_QUEUE_TABLE_S

Columns[edit]

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[edit]

Primary Key Columns
SYS_C005070 SUBSCRIBER_ID

Check Constraints[edit]

Check Constraint Expression Description
SYS_C005068 "SUBSCRIBER_ID" IS NOT NULL
SYS_C005069 "QUEUE_NAME" IS NOT NULL
Retrieved from "http://dbshelp.devio.at/index.php?title=IX.AQ$_STREAMS_QUEUE_TABLE_S_(table)&oldid=3056"