IX Sample Schema Table Descriptions

Previous Next JavaScript must be enabled to correctly display this content

4.9 IX Sample Schema Table Descriptions

Consider the columns of each table of IX sample schema.

4.9.1 Table IX.ORDERS_QUEUETABLE

Table 4-24 IX.ORDERS_QUEUETABLE Table Description

Column Name	Null?	Type
`Q_NAME`		`VARCHAR2(30)`
`MSGID`	`NOT NULL`	`RAW(16)`
`CORRID`		`VARCHAR2(128)`
`PRIORITY`		`NUMBER`
`STATE`		`NUMBER`
`DELAY`		`TIMESTAMP(6)`
`EXPIRATION`		`NUMBER`
`TIME_MANAGER_INFO`		`TIMESTAMP(6)`
`LOCAL_ORDER_NO`		`NUMBER`
`CHAIN_NO`		`NUMBER`
`CSCN`		`NUMBER`
`DSCN`		`NUMBER`
`ENQ_TIME`		`TIMESTAMP(6)`
`ENQ_UID`		`VARCHAR2(30)`
`ENQ_TID`		`VARCHAR2(30)`
`DEQ_TIME`		`TIMESTAMP(6)`
`EEQ_UID`		`VARCHAR2(30)`
`DEQ_TID`		`VARCHAR2(30)`
`RETRY_COUNT`		`NUMBER`
`EXCEPTION_QSCHEMA`		`VARCHAR2(30)`
`EXCEPTION_QUEUE`		`VARCHAR2(30)`
`STEP_NO`		`NUMBER`
`RECIPIENT_KEY`		`NUMBER`
`DEQUEUE_MSGID`		`RAW(16)`
`SENDER_NAME`		`VARCHAR2(30)`
`SENDER_ADDRESS`		`VARCHAR2(1024)`
`SENDER_PROTOCOL`		`NUMBER`
`USER_DATA`		`ORDER_EVENT_TYP`
`USER_PROP`		`SYS.ANYDATA`

4.9.2 Table IX.STREAMS_QUEUE_TABLE

Table 4-25 IX.STREAMS_QUEUE_TABLE Table Description

Column Name	Null?	Type
`Q_NAME`		`VARCHAR2(30)`
`MSGID`	`NOT NULL`	`RAW(16)`
`CORRID`		`VARCHAR2(128)`
`PRIORITY`		`NUMBER`
`STATE`		`NUMBER`
`DELAY`		`TIMESTAMP(6)`
`EXPIRATION`		`NUMBER`
`TIME_MANAGER_INFO`		`TIMESTAMP(6)`
`LOCAL_ORDER_NO`		`NUMBER`
`CHAIN_NO`		`NUMBER`
`CSCN`		`NUMBER`
`DSCN`		`NUMBER`
`ENQ_TIME`		`TIMESTAMP(6)`
`ENQ_UID`		`VARCHAR2(30)`
`ENQ_TID`		`VARCHAR2(30)`
`DEQ_TIME`		`TIMESTAMP(6)`
`EEQ_UID`		`VARCHAR2(30)`
`DEQ_TID`		`VARCHAR2(30)`
`RETRY_COUNT`		`NUMBER`
`EXCEPTION_QSCHEMA`		`VARCHAR2(30)`
`EXCEPTION_QUEUE`		`VARCHAR2(30)`
`STEP_NO`		`NUMBER`
`RECIPIENT_KEY`		`NUMBER`
`DEQUEUE_MSGID`		`RAW(16)`
`SENDER_NAME`		`VARCHAR2(30)`
`SENDER_ADDRESS`		`VARCHAR2(1024)`
`SENDER_PROTOCOL`		`NUMBER`
`USER_DATA`		`ORDER_EVENT_TYP`
`USER_PROP`		`SYS.ANYDATA`