Table rice-2.1.1.krew_rte_node_instn_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_INSTN_ID varchar 40
krew_actn_rqst_t.RTE_NODE_INSTN_ID Implied Constraint R
krew_init_rte_node_instn_t.RTE_NODE_INSTN_ID Implied Constraint R
krew_rte_node_instn_st_t.RTE_NODE_INSTN_ID Implied Constraint R
DOC_HDR_ID varchar 40
krew_doc_hdr_cntnt_t.DOC_HDR_ID Implied Constraint R
RTE_NODE_ID varchar 40
krew_rte_node_t.RTE_NODE_ID Implied Constraint R
BRCH_ID varchar 40  √  null
PROC_RTE_NODE_INSTN_ID varchar 40  √  null
ACTV_IND decimal 1 0
CMPLT_IND decimal 1 0
INIT_IND decimal 1 0
VER_NBR decimal 8  √  0

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

Indexes:
Column(s) Type Sort Constraint Name
RTE_NODE_INSTN_ID Primary key Asc PRIMARY
DOC_HDR_ID + ACTV_IND + CMPLT_IND Performance Asc/Asc/Asc KREW_RTE_NODE_INSTN_TI1
RTE_NODE_ID Performance Asc KREW_RTE_NODE_INSTN_TI2
BRCH_ID Performance Asc KREW_RTE_NODE_INSTN_TI3
PROC_RTE_NODE_INSTN_ID Performance Asc KREW_RTE_NODE_INSTN_TI4

Close relationships: