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_H

Columns

Column Datatype Nullable Default value Comment
MSGID RAW(16) N    
SUBSCRIBER# NUMBER(,) N    
NAME VARCHAR2(30) N    
ADDRESS# NUMBER(,) N    
DEQUEUE_TIME DATE Y    
TRANSACTION_ID VARCHAR2(30) Y    
DEQUEUE_USER NUMBER(,) Y    
PROPAGATED_MSGID RAW(16) Y    
RETRY_COUNT NUMBER(,) Y    
HINT ROWID(10) Y    
SPARE RAW(16) Y    

Primary key

Primary key Columns
SYS_IOT_TOP_29879 MSGID, SUBSCRIBER#, NAME, ADDRESS#

Indexes

Index Type Uniqueness Columns
SYS_IOT_TOP_29879 IOT - TOP UNIQUE MSGID, SUBSCRIBER#, NAME, ADDRESS#

Options

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


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