Table rice-2.1.1.krim_grp_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_ID varchar 40
krew_actn_itm_t.GRP_ID Implied Constraint R
krew_actn_rqst_t.GRP_ID Implied Constraint R
krew_doc_typ_t.GRP_ID Implied Constraint R
krew_out_box_itm_t.GRP_ID Implied Constraint R
krew_rte_node_t.GRP_ID Implied Constraint R
krim_grp_attr_data_t.GRP_ID KRIM_GRP_ATTR_DATA_TR3 C
krim_grp_document_t.GRP_ID Implied Constraint R
krim_grp_mbr_t.GRP_ID KRIM_GRP_MBR_TR1 C
krim_grp_mbr_v.GRP_ID Implied Constraint R
krim_grp_v.GRP_ID Implied Constraint R
krim_pnd_grp_attr_data_t.GRP_ID Implied Constraint R
krim_pnd_grp_mbr_t.GRP_ID Implied Constraint R
krim_pnd_grp_prncpl_mt.GRP_ID Implied Constraint R
OBJ_ID varchar 36
VER_NBR decimal 8 1
GRP_NM varchar 80
NMSPC_CD varchar 40
GRP_DESC varchar 4000  √  null
KIM_TYP_ID varchar 40
krim_typ_t.KIM_TYP_ID KRIM_GRP_TR1 R
ACTV_IND varchar 1  √  Y
LAST_UPDT_DT datetime 19  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
GRP_ID Primary key Asc PRIMARY
OBJ_ID Must be unique Asc KRIM_GRP_TC0
GRP_NM + NMSPC_CD Must be unique Asc/Asc KRIM_GRP_TC1
KIM_TYP_ID Performance Asc KRIM_GRP_TR1

Close relationships  within of separation: