View lawprod.MSCM.DECONTAM_DETAILS 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
CASECART_NO varchar2 8
CASECART.CASECART_NO Implied Constraint R
CARTSET_ASSM_NO varchar2 10
CASECART_ASSEMBLY.CARTSET_ASSM_NO Implied Constraint R
ASID varchar2 10
TL_NO varchar2 6
TRAYLIST_NAME varchar2 100
ACT_DATE date 7

Analyzed at Wed May 18 12:10 CDT 2011

View Definition:
SELECT DISTINCT CASECART_ASSEMBLY.CASECART_NO, CASECART_ASSEMBLY.CARTSET_ASSM_NO, CASECART_ITEMS.TS_NO AS ASID, TRAY_LIST.TL_NO, TRAY_LIST.DESCR AS TRAYLIST_NAME, CASECART_ITEMS.ACT_DATE FROM CASECART_ASSEMBLY, CASECART_ITEMS, TRAY_LIST, TRAYSET WHERE CASECART_ASSEMBLY.CARTSET_ASSM_NO = CASECART_ITEMS.CARTSET_ASSM_NO AND TRAYSET.TS_NO = CASECART_ITEMS.TS_NO AND TRAY_LIST.TL_ID = TRAYSET.TL_ID
 
Possibly Referenced Tables/Views:
CASECART_ASSEMBLY CASECART_ITEMS TRAY_LIST TRAYSET 


Close relationships: