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$_AQ$_MEM_MC_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_C002558 SUBSCRIBER_ID

Check constraints

Check constraint Check condition
SYS_C002556 "SUBSCRIBER_ID" IS NOT NULL
SYS_C002557 "QUEUE_NAME" IS NOT NULL

Indexes

Index Type Uniqueness Columns
SYS_C002558 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