SchemaSpy - Table rice-2.2.0-SNAPSHOT.krim_entity

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

ENTITY_ID

varchar

krim_entity_afltn_t.ENTITY_ID	KRIM_ENTITY_AFLTN_TR1 C
krim_entity_ctznshp_t.ENTITY_ID	KRIM_ENTITY_CTZNSHP_TR1 C
krim_entity_emp_info_t.ENTITY_ID	KRIM_ENTITY_EMP_INFO_TR1 C
krim_entity_ent_typ_t.ENTITY_ID	KRIM_ENTITY_ENT_TYP_TR1 C
krim_entity_ethnic_t.ENTITY_ID	KRIM_ENTITY_ETHNIC_TR1 R
krim_entity_ext_id_t.ENTITY_ID	KRIM_ENTITY_EXT_ID_TR1 C
krim_entity_nm_t.ENTITY_ID	KRIM_ENTITY_NM_TR1 C
krim_entity_residency_t.ENTITY_ID	KRIM_ENTITY_RESIDENCY_TR1 R
krim_entity_visa_t.ENTITY_ID	KRIM_ENTITY_VISA_TR1 R
krim_prncpl_t.ENTITY_ID	KRIM_PRNCPL_TR1 C

Implied Constraint R

OBJ_ID

varchar

VER_NBR

decimal

ACTV_IND

varchar

√

LAST_UPDT_DT

datetime

√

null

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

Indexes:

Column(s)	Type	Sort	Constraint Name
ENTITY_ID	Primary key	Asc	PRIMARY
OBJ_ID	Must be unique	Asc	KRIM_ENTITY_TC0