Table lawprod.MSCM.TRAY 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
TRAY_ID number 22
TRAY_TYPE number 22  √  null
TRAY_NO varchar2 5
ASSEMBLY_DECONTAM_VW.TRAY_NO Implied Constraint R
INSTRUMENT_BY_LOCATION_VIEW.TRAY_NO Implied Constraint R
LOAD_TRACKING_INFO_TRAY.TRAY_NO Implied Constraint R
PICKING_DETAILS.TRAY_NO Implied Constraint R
TRAY_ACTIVITY_VW.TRAY_NO Implied Constraint R
TRAY_INV_REP_VW.TRAY_NO Implied Constraint R
TRAY_ON_HOLD_VW.TRAY_NO Implied Constraint R
TRAY_ROTATION_TIME_VW.TRAY_NO Implied Constraint R
TRAY_USAGE.TRAY_NO Implied Constraint R
TRAYSET.TRAY_NO Implied Constraint R
TRAYSET_CURRENT_VW.TRAY_NO Implied Constraint R
TRAYSET_TRAY.TRAY_NO Implied Constraint R
TL_NO varchar2 6  √  null
HOT_TRAY_IND char 1

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
TRAY_NO Primary key Asc SYS_C00913942

Close relationships: