Table rice-2.1.1.krns_nte_typ_t Generated by
SchemaSpy
Legend: SourceForge.net
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
NTE_TYP_CD varchar 4
krns_nte_t.NTE_TYP_CD KRNS_NTE_TR1 R
OBJ_ID varchar 36
VER_NBR decimal 8 1
TYP_DESC_TXT varchar 100  √  null
ACTV_IND varchar 1  √  null

Table contained 2 rows at Tue Sep 18 22:24 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
NTE_TYP_CD Primary key Asc PRIMARY
OBJ_ID Must be unique Asc KRNS_NTE_TYP_TC0

Close relationships  within of separation: