Table lawprod.MSCM.LOAD_CONTENT 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
DB_ID number 22
PROC_STAGE.DB_ID Implied Constraint R
LOAD_ID number 22
LOAD_STER.LOAD_ID SYS_C00914026 R
ASID varchar2 10
TRAYSET.TS_NO SYS_C00914027 R
BATCH_NO varchar2 20  √  null
BATCH.BATCH_NO Implied Constraint R
DESCRIPTION varchar2 100  √  null
COMMENTS varchar2 50  √  null
ADDED_BY number 22
USERS.USER_ID SYS_C00914028 R
ADDED_DATE date 7

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
DB_ID Primary key Asc SYS_C00914025
ASID Performance Asc IDX_LC_ASID
LOAD_ID Performance Asc LOADCNTNT_LDID_IDX

Close relationships  within of separation: