Table rice-2.1.1.krew_ppl_flw_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
PPL_FLW_MBR_ID varchar 40
krew_ppl_flw_dlgt_t.PPL_FLW_MBR_ID KREW_PPL_FLW_DLGT_FK1 R
PPL_FLW_ID varchar 40
krew_ppl_flw_t.PPL_FLW_ID KREW_PPL_FLW_MBR_FK1 R
MBR_TYP_CD varchar 1
MBR_ID varchar 40
PRIO decimal 8  √  null
VER_NBR decimal 8 0
ACTN_RQST_PLCY_CD varchar 1  √  null
RSP_ID varchar 40
krim_rsp_t.RSP_ID Implied Constraint R

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

Indexes:
Column(s) Type Sort Constraint Name
PPL_FLW_MBR_ID Primary key Asc PRIMARY
PPL_FLW_ID Performance Asc KREW_PPL_FLW_MBR_TI1
PPL_FLW_ID + PRIO Performance Asc/Asc KREW_PPL_FLW_MBR_TI2

Close relationships  within of separation: