SchemaSpy - Table lawprod.MSCM.TRANSFER_LOG

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

TR_LOG_ID

number

22

TR_LOG_NO

varchar2

30

TRANSFER_NO

varchar2

20

TRANSFER.TRANSFER_NO

SYS_C00914146 R

TRANSFER_ITEM

varchar2

30

√

null

FROM_LOC_NO

number

22

√

null

LOCATION.LOCATION_ID

SYS_C00914147 R

FROM_BIN

varchar2

7

√

null

TO_LOC_NO

number

22

√

null

LOCATION.LOCATION_ID

SYS_C00914148 R

TO_BIN

varchar2

7

√

null

TYPE

number

22

TIME

date

7

STATUS

number

22

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
TR_LOG_NO	Primary key	Asc	SYS_C00914145