Overview Tables Views Indexes Constraints Triggers Procedures Functions Packages Sequences Index

QS


Description  Columns  Primary key  Check constraints  Foreign keys  Unique keys  Indexes  Options  Referenced by  Triggers  

AQ$_QS_ORDERS_PR_MQTAB_S

Columns

Column Datatype Nullable Default value Comment
SUBSCRIBER_ID NUMBER(,) N    
QUEUE_NAME VARCHAR2(30) N    
NAME VARCHAR2(30) Y    
ADDRESS VARCHAR2(1024) Y    
PROTOCOL NUMBER(,) Y    
SUBSCRIBER_TYPE NUMBER(,) Y    
RULE_NAME VARCHAR2(30) Y    
TRANS_NAME VARCHAR2(61) Y    
RULESET_NAME VARCHAR2(61) Y    

Primary key

Primary key Columns
SYS_C002547 SUBSCRIBER_ID

Check constraints

Check constraint Check condition
SYS_C002545 "SUBSCRIBER_ID" IS NOT NULL
SYS_C002546 "QUEUE_NAME" IS NOT NULL

Indexes

Index Type Uniqueness Columns
SYS_C002547 NORMAL UNIQUE SUBSCRIBER_ID

Options

Option Setting
Clustered N
Generated by Oracle N
Index Organized N
Logging Y
Partitioned N
Temporary N
Nested N


Generated by
OraDoclet, Copyright © Oracle Corporation 2005      Last updated: 01.01.2005