Table rice-2.2.0-SNAPSHOT.krim_dlgn_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
DLGN_MBR_ID varchar 40
krim_dlgn_mbr_attr_data_t.DLGN_MBR_ID Implied Constraint R
krim_pnd_dlgn_mbr_attr_data_t.DLGN_MBR_ID Implied Constraint R
krim_pnd_dlgn_mbr_t.DLGN_MBR_ID Implied Constraint R
VER_NBR decimal 8 1
OBJ_ID varchar 36
DLGN_ID varchar 40  √  null
krim_dlgn_t.DLGN_ID KRIM_DLGN_MBR_TR2 R
MBR_ID varchar 40  √  null
MBR_TYP_CD char 1  √  P
ACTV_FRM_DT datetime 19  √  null
ACTV_TO_DT datetime 19  √  null
LAST_UPDT_DT datetime 19  √  null
ROLE_MBR_ID varchar 40  √  null
krim_role_mbr_t.ROLE_MBR_ID Implied Constraint R

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

Indexes:
Column(s) Type Sort Constraint Name
DLGN_MBR_ID Primary key Asc PRIMARY
OBJ_ID Must be unique Asc KRIM_DLGN_MBR_TC0
DLGN_ID Performance Asc KRIM_DLGN_MBR_TR2

Close relationships  within of separation: