Table rice-2.2.0-SNAPSHOT.krim_grp_mbr_t Generated by
SchemaSpy
Legend: SourceForge.net
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
GRP_MBR_ID varchar 40
krim_pnd_grp_mbr_t.GRP_MBR_ID Implied Constraint R
krim_pnd_grp_prncpl_mt.GRP_MBR_ID Implied Constraint R
VER_NBR decimal 8 1
OBJ_ID varchar 36
GRP_ID varchar 40
krim_grp_t.GRP_ID KRIM_GRP_MBR_TR1 C
MBR_ID varchar 40
MBR_TYP_CD char 1 P
ACTV_FRM_DT datetime 19  √  null
ACTV_TO_DT datetime 19  √  null
LAST_UPDT_DT datetime 19  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
GRP_MBR_ID Primary key Asc PRIMARY
OBJ_ID Must be unique Asc KRIM_GRP_MBR_TC0
MBR_ID Performance Asc KRIM_GRP_MBR_TI1
GRP_ID Performance Asc KRIM_GRP_MBR_TR1

Close relationships  within of separation: