Table lawprod.MSCM.LOAD_STER 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
LOAD_ID number 22
CONTENT_RESULT.LOAD_ID SYS_C00914044 R
CONTENT_RESULT_LOG.LOAD_ID SYS_C00914059 R
LOAD_CONTENT.LOAD_ID SYS_C00914026 R
LOAD_CONTENT_LOG.LOAD_ID SYS_C00914050 R
LOAD_RESULT.LOAD_ID SYS_C00914035 R
LOAD_RESULT_LOG.LOAD_ID SYS_C00914054 R
LOAD_TRACKING_INFO.LOAD_ID Implied Constraint R
LOAD_TRACKING_INFO_TRAY.LOAD_ID Implied Constraint R
STER_LOAD_HISTORY_VW.LOAD_ID Implied Constraint R
CYCLE_NO varchar2 50  √  null
PROC_NO number 22
PROCESS.PROCESS_NO SYS_C00914017 R
STERILIZER_EQ_NO number 8
STERILIZER_EQUIPMENT.STERILIZER_EQ_NO SYS_C00914018 R
COMMENTS varchar2 100  √  null
CREATED_BY number 22
USERS.USER_ID SYS_C00914019 R
STATUS number 22
CREATED_DATE date 7
END_DATE date 7  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
LOAD_ID Primary key Asc SYS_C00914016

Close relationships  within of separation: