SchemaSpy - Table rice-2.0.krew_typ_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

TYP_ID

varchar

40

krew_ppl_flw_t.TYP_ID	KREW_PPL_FLW_FK1 R
krew_typ_attr_t.TYP_ID	KREW_TYP_ATTR_FK2 R
krms_actn_t.TYP_ID	Implied Constraint R
krms_agenda_t.TYP_ID	Implied Constraint R
krms_cntxt_t.TYP_ID	Implied Constraint R
krms_rule_t.TYP_ID	Implied Constraint R
krms_typ_t.TYP_ID	Implied Constraint R

NM

varchar

100

NMSPC_CD

varchar

40

SRVC_NM

varchar

200

√

null

ACTV

varchar

1

Y

VER_NBR

decimal

8

0

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

Indexes:

Column(s)	Type	Sort	Constraint Name
TYP_ID	Primary key	Asc	PRIMARY
NM + NMSPC_CD	Must be unique	Asc/Asc	KREW_TYP_TC1