SchemaSpy - Table lawprod.MSCM.REQUEST_QUEUE

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

REQUEST_QUEUE_SEQ

number

22

CHARGE_DTL_ID

number

22

CHARGE_DETAIL.CHARGE_DTL_ID

SYS_C00914804 R

ITEM_ID

number

22

ITEM.ITEM_ID

SYS_C00914805 R

SUPPLY_LOCATION_ID

number

22

QTY

number

13

UOM

varchar2

4

LAST_UPDATE_DATE

date

7

REPLENISHMENT_TYPE

char

1

'0'

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
REQUEST_QUEUE_SEQ	Primary key	Asc	SYS_C00914803
REQUEST_QUEUE_SEQ + CHARGE_DTL_ID + ITEM_ID + SUPPLY_LOCATION_ID	Must be unique	Asc/Asc/Asc/Asc	IDX_ITEM_SUPP_LOC