Table rice-2.1.1.krew_rte_node_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
RTE_NODE_ID varchar 40
krew_rte_node_cfg_parm_t.RTE_NODE_ID Implied Constraint R
krew_rte_node_instn_t.RTE_NODE_ID Implied Constraint R
DOC_TYP_ID varchar 40  √  null
krew_doc_typ_t.DOC_TYP_ID Implied Constraint R
NM varchar 255
TYP varchar 255
RTE_MTHD_NM varchar 255  √  null
RTE_MTHD_CD varchar 2  √  null
FNL_APRVR_IND decimal 1  √  null
MNDTRY_RTE_IND decimal 1  √  null
ACTVN_TYP varchar 250  √  null
BRCH_PROTO_ID varchar 40  √  null
VER_NBR decimal 8  √  0
CONTENT_FRAGMENT varchar 4000  √  null
GRP_ID varchar 40  √  null
krim_grp_t.GRP_ID Implied Constraint R
NEXT_DOC_STAT varchar 64  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
RTE_NODE_ID Primary key Asc PRIMARY
NM + DOC_TYP_ID Performance Asc/Asc KREW_RTE_NODE_TI1
DOC_TYP_ID + FNL_APRVR_IND Performance Asc/Asc KREW_RTE_NODE_TI2
BRCH_PROTO_ID Performance Asc KREW_RTE_NODE_TI3
DOC_TYP_ID Performance Asc KREW_RTE_NODE_TI4

Close relationships: