View lawprod.MSCM.DECONTAM_DETAILS_HELP 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
NUMBER_OF_TRAYSET number 22  √  null
USER_ID number 22
USERS.USER_ID Implied Constraint R
ASM_LOC_NO number 22

Analyzed at Wed May 18 12:10 CDT 2011

View Definition:
SELECT COUNT(TS_NO) AS NUMBER_OF_TRAYSET, USER_ID, ASM_LOC_NO FROM ASSEMBLY GROUP BY USER_ID,ASM_LOC_NO
 
Possibly Referenced Tables/Views:
ASSEMBLY 


Close relationships: