Table lawprod.MSCM.TRAYSET 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
TS_ID number 22
TS_NO varchar2 10
ASSEMBLY.TS_NO SYS_C00913967 R
ASSEMBLY_DECONTAM_VW.TS_NO Implied Constraint R
BATCH_ITEMS.TS_NO SYS_C00914077 R
CASECART_ITEMS.TS_NO SYS_C00914111 R
CONTENT_RESULT.ASID SYS_C00914046 R
CONTENT_RESULT_LOG.ASID SYS_C00914061 R
LOAD_CONTENT.ASID SYS_C00914027 R
TRANSFER.TS_NO SYS_C00914135 R
TRAY_ACTIVITY_VW.TS_NO Implied Constraint R
TRAY_USAGE.TS_NO Implied Constraint R
TRAYSET_CURRENT_VW.TS_NO Implied Constraint R
TRAYSET_TRAY.TS_NO Implied Constraint R
TS_TIME date 7
TS_TYPE number 22
TRAY_NO varchar2 5
TRAY.TRAY_NO Implied Constraint R
TL_ID number 22  √  null
TRAY_LIST.TL_ID Implied Constraint R
ASSM_LOC_NO number 22  √  null
LOCATION.LOCATION_ID SYS_C00913952 R
USER_ID number 22
USERS.USER_ID SYS_C00913953 R
CREAT_DT date 7  √  null
ASSM_DT date 7  √  null
MOD_DT date 7  √  null
TOTAL number 22
STATUS number 22
HOLD_IND char 1  √  null
ON_HOLD_COMMENT varchar2 1000  √  null
COMMENTS varchar2 1000  √  null
TRAYSET_BIN varchar2 7  √  null
STER_DONE varchar2 1 'N'

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
TS_NO Primary key Asc SYS_C00913951
STATUS Performance Asc IDX_STATUS
TL_ID Performance Asc IDX_TLID
TS_ID Performance Asc TRAYSET_TS_ID_IDX
TRAY_NO + TS_ID Performance Asc/Asc TRAYSET_TSID_IDX

Close relationships  within of separation: