Table lawprod.MSCM.NOTE_TYPE 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_TYPE varchar2 10
NOTE.NOTE_TYPE SYS_C00913600 R
APP_ID number 22
APP_CONFIG.APP_ID SYS_C00913595 R
IS_ACTIVE char 1 'A'
SEQUENCE_NO number 22  √  null
DESCRIPTION varchar2 50  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
NOTE_TYPE Primary key Asc SYS_C00913594

Close relationships  within of separation: