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  

QS_ORDERS_SQTAB

Columns

Column Datatype Nullable Default value Comment
Q_NAME VARCHAR2(30) Y    
MSGID RAW(16) N    
CORRID VARCHAR2(128) Y    
PRIORITY NUMBER(,) Y    
STATE NUMBER(,) Y    
DELAY DATE Y    
EXPIRATION NUMBER(,) Y    
TIME_MANAGER_INFO DATE Y    
LOCAL_ORDER_NO NUMBER(,) Y    
CHAIN_NO NUMBER(,) Y    
CSCN NUMBER(,) Y    
DSCN NUMBER(,) Y    
ENQ_TIME DATE Y    
ENQ_UID NUMBER(,) Y    
ENQ_TID VARCHAR2(30) Y    
DEQ_TIME DATE Y    
DEQ_UID NUMBER(,) Y    
DEQ_TID VARCHAR2(30) Y    
RETRY_COUNT NUMBER(,) Y    
EXCEPTION_QSCHEMA VARCHAR2(30) Y    
EXCEPTION_QUEUE VARCHAR2(30) Y    
STEP_NO NUMBER(,) Y    
RECIPIENT_KEY NUMBER(,) Y    
DEQUEUE_MSGID RAW(16) Y    
SENDER_NAME VARCHAR2(30) Y    
SENDER_ADDRESS VARCHAR2(1024) Y    
SENDER_PROTOCOL NUMBER(,) Y    
USER_DATA ORDER_TYP(1) Y    

Primary key

Primary key Columns
SYS_C002542 MSGID

Indexes

Index Type Uniqueness Columns
AQ$_QS_ORDERS_SQTAB_I NORMAL NONUNIQUE Q_NAME, STATE, ENQ_TID, ENQ_TIME, STEP_NO, CHAIN_NO, LOCAL_ORDER_NO
AQ$_QS_ORDERS_SQTAB_T NORMAL NONUNIQUE TIME_MANAGER_INFO
SYS_C002542 NORMAL UNIQUE MSGID

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