SchemaSpy - Table rice-2.2.0-SNAPSHOT.krim_pnd_dlgn_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

FDOC_NBR

varchar

14

trvl_auth_doc_t.FDOC_NBR

Implied Constraint R

DLGN_ID

varchar

40

krim_dlgn_t.DLGN_ID

Implied Constraint R

ROLE_ID

varchar

40

krim_role_t.ROLE_ID

Implied Constraint R

OBJ_ID

varchar

36

VER_NBR

decimal

8

1

KIM_TYP_ID

varchar

40

√

null

krim_typ_t.KIM_TYP_ID

Implied Constraint R

DLGN_TYP_CD

varchar

100

ACTV_IND

varchar

1

√

Y

Table contained 0 rows at Fri May 10 14:36 PDT 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
FDOC_NBR + DLGN_ID	Primary key	Asc/Asc	PRIMARY