SchemaSpy - Table rice-2.1.1.krim_rsp_tmpl_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

RSP_TMPL_ID

varchar

40

krim_rsp_t.RSP_TMPL_ID

KRIM_RSP_TR1 R

OBJ_ID

varchar

36

VER_NBR

decimal

8

1

NMSPC_CD

varchar

40

NM

varchar

100

KIM_TYP_ID

varchar

100

krim_typ_t.KIM_TYP_ID

KRIM_RSP_TMPL_TR1 R

DESC_TXT

varchar

400

√

null

ACTV_IND

varchar

1

√

Y

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

Indexes:

Column(s)	Type	Sort	Constraint Name
RSP_TMPL_ID	Primary key	Asc	PRIMARY
OBJ_ID	Must be unique	Asc	KRIM_RSP_TMPL_TC0
NM + NMSPC_CD	Must be unique	Asc/Asc	KRIM_RSP_TMPL_TC1
KIM_TYP_ID	Performance	Asc	KRIM_RSP_TMPL_TR1