SchemaSpy - Table lawprod.MSCM.LOCATION_ITEM_BIN

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

LOCATION_ITEM_ID

number

20

LOCATION_ITEM.LOCATION_ITEM_ID

SYS_C00913510 R

LOCATION_ID

number

22

LOCATION_BIN.LOCATION_ID

LOC_ITEM_BIN_FK R

BIN

varchar2

7

LOCATION_BIN.BIN

LOC_ITEM_BIN_FK R

UOM

varchar2

4

CREATION_DT

date

7

LAST_MODIFIED_DT

date

7

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
LOCATION_ITEM_ID + BIN + UOM	Primary key	Asc/Asc/Asc	LOC_ITEM_BIN_PK