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

krim_pnd_afltn_mt.FDOC_NBR

KRIM_PND_AFLTN_MT_FK1 R

trv_doc_2.FDOC_NBR

Implied Constraint R

ENTITY_ID

varchar

40

krim_entity_priv_pref_t.ENTITY_ID

Implied Constraint R

OBJ_ID

varchar

36

VER_NBR

decimal

8

1

PRNCPL_ID

varchar

40

krim_prncpl_t.PRNCPL_ID

Implied Constraint R

PRNCPL_NM

varchar

100

PRNCPL_PSWD

varchar

400

√

null

UNIV_ID

varchar

40

√

null

ACTV_IND

varchar

1

√

Y

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

Indexes:

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