Table rice-2.0.krns_nte_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_ID decimal 14 0
krns_att_t.NTE_ID KRNS_ATT_TR1 R
OBJ_ID varchar 36
VER_NBR decimal 8 1
RMT_OBJ_ID varchar 36
AUTH_PRNCPL_ID varchar 40
POST_TS datetime 19
NTE_TYP_CD varchar 4
krns_nte_typ_t.NTE_TYP_CD KRNS_NTE_TR1 R
TXT varchar 800  √  null
PRG_CD varchar 1  √  null
TPC_TXT varchar 40  √  null

Table contained 0 rows at Mon May 07 20:18 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
NTE_ID Primary key Asc PRIMARY
OBJ_ID Must be unique Asc KRNS_NTE_TC0
NTE_TYP_CD Performance Asc KRNS_NTE_TR1

Close relationships: