IX AQ$_STREAMS_QUEUE_TABLE_S (table)

wikibot

TableIX.AQ$_STREAMS_QUEUE_TABLE_S

Columns

ColumnData TypeNullableDefaultDescription
SUBSCRIBER_IDNUMBERnot null  
QUEUE_NAMEVARCHAR2(30)not null  
NAMEVARCHAR2(30)null  
ADDRESSVARCHAR2(1024)null  
PROTOCOLNUMBERnull  
SUBSCRIBER_TYPENUMBERnull  
RULE_NAMEVARCHAR2(30)null  
TRANS_NAMEVARCHAR2(61)null  
RULESET_NAMEVARCHAR2(65)null  
NEGATIVE_RULESET_NAMEVARCHAR2(65)null  

Primary Key

Primary KeyColumns
SYS_C005070SUBSCRIBER_ID

Check Constraints

Check ConstraintExpressionDescription
SYS_C005068"SUBSCRIBER_ID" IS NOT NULL 
SYS_C005069"QUEUE_NAME" IS NOT NULL