SchemaSpy - Table rice-2.1.1.krns_nte_t

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

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 Tue Sep 18 22:24 PDT 2012

Indexes:

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