Table lawprod.MSCM.NOTE 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
NOTE_ID number 20
DELIVERY_UNIT.NOTE_ID SYS_C00914388 R
DISTRIB_LINE.NOTE_ID SYS_C00914524 R
RECEIPT_HEADER.NOTE_ID SYS_C00913780 R
RECEIPT_LOG_VW.NOTE_ID Implied Constraint R
NOTE_TYPE varchar2 10
NOTE_TYPE.NOTE_TYPE SYS_C00913600 R
LOCATION_ID number 22
LOCATION.LOCATION_ID SYS_C00913601 R
NOTE_CONTENT varchar2 1000  √  null
CREATION_DT date 7  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
NOTE_ID Primary key Asc SYS_C00913599

Close relationships  within of separation: