SchemaSpy - Table lawprod.MSCM.WORKSTATION_SUPPLY_LOCATION

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

WS_SUPPLY_LOC_ID

number

22

LOCATION_ID

number

22

LOCATION.LOCATION_ID

SYS_C00914727 R

WORKSTATION_ID

number

22

WORKSTATION.WORKSTATION_ID

SYS_C00914728 R

CREATE_DATE

date

7

LAST_UPDATE_DATE

date

7

√

null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
WS_SUPPLY_LOC_ID	Primary key	Asc	SYS_C00914726
LOCATION_ID + WORKSTATION_ID	Must be unique	Asc/Asc	IDX_WS_SUPPLY_LOC