Table rice-2.2.0-SNAPSHOT.krew_doc_typ_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
DOC_TYP_ID varchar 40
krew_doc_hdr_t.DOC_TYP_ID Implied Constraint R
krew_doc_typ_app_stat_cat_t.DOC_TYP_ID KREW_DOC_TYP_APP_STAT_CAT_FK1 R
krew_doc_typ_attr_t.DOC_TYP_ID Implied Constraint R
krew_doc_typ_plcy_reln_t.DOC_TYP_ID Implied Constraint R
krew_doc_typ_proc_t.DOC_TYP_ID Implied Constraint R
krew_rte_node_t.DOC_TYP_ID Implied Constraint R
PARNT_ID varchar 40  √  null
DOC_TYP_NM varchar 64  √  null
DOC_TYP_VER_NBR decimal 10  √  0
ACTV_IND decimal 1  √  null
CUR_IND decimal 1  √  null
LBL varchar 128
PREV_DOC_TYP_VER_NBR varchar 40  √  null
DOC_TYP_DESC varchar 4000  √  null
DOC_HDLR_URL varchar 255  √  null
POST_PRCSR varchar 255  √  null
JNDI_URL varchar 255  √  null
BLNKT_APPR_PLCY varchar 10  √  null
ADV_DOC_SRCH_URL varchar 255  √  null
RTE_VER_NBR varchar 2  √  1
NOTIFY_ADDR varchar 255  √  null
APPL_ID varchar 255  √  null
EMAIL_XSL varchar 255  √  null
SEC_XML longtext 2147483647  √  null
VER_NBR decimal 8  √  0
BLNKT_APPR_GRP_ID varchar 40  √  null
RPT_GRP_ID varchar 40  √  null
GRP_ID varchar 40  √  null
krim_grp_t.GRP_ID Implied Constraint R
HELP_DEF_URL varchar 4000  √  null
OBJ_ID varchar 36
DOC_SEARCH_HELP_URL varchar 4000  √  null
DOC_HDR_ID varchar 40  √  null
krew_doc_hdr_cntnt_t.DOC_HDR_ID Implied Constraint R
AUTHORIZER varchar 255  √  null

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
DOC_TYP_ID Primary key Asc PRIMARY  
OBJ_ID Must be unique Asc KREW_DOC_TYP_TC0  
DOC_TYP_NM + DOC_TYP_VER_NBR Must be unique Asc/Asc KREW_DOC_TYP_TI1 These unique columns are also nullable
PARNT_ID Performance Asc KREW_DOC_TYP_TI2  
DOC_TYP_ID + PARNT_ID Performance Asc/Asc KREW_DOC_TYP_TI3  
PREV_DOC_TYP_VER_NBR Performance Asc KREW_DOC_TYP_TI4  
CUR_IND Performance Asc KREW_DOC_TYP_TI5  
DOC_TYP_NM Performance Asc KREW_DOC_TYP_TI6  

Close relationships  within of separation: