Table rice-2.2.0-SNAPSHOT.krew_actn_rqst_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
ACTN_RQST_ID varchar 40
krew_actn_itm_t
krew_out_box_itm_t
PARNT_ID varchar 40  √  null
ACTN_RQST_CD char 1
DOC_HDR_ID varchar 40
krew_doc_hdr_cntnt_t
RULE_ID varchar 40  √  null
krms_rule_t
STAT_CD char 1
RSP_ID varchar 40
krim_rsp_t
PRNCPL_ID varchar 40  √  null
krim_prncpl_t
ROLE_NM varchar 2000  √  null
QUAL_ROLE_NM varchar 2000  √  null
QUAL_ROLE_NM_LBL_TXT varchar 2000  √  null
RECIP_TYP_CD char 1  √  null
PRIO_NBR decimal 8
RTE_TYP_NM varchar 255  √  null
RTE_LVL_NBR decimal 8
RTE_NODE_INSTN_ID varchar 40  √  null
krew_rte_node_instn_t
ACTN_TKN_ID varchar 40  √  null
krew_actn_tkn_t
DOC_VER_NBR decimal 8
CRTE_DT datetime 19
RSP_DESC_TXT varchar 200  √  null
FRC_ACTN decimal 1  √  0
ACTN_RQST_ANNOTN_TXT varchar 2000  √  null
DLGN_TYP char 1  √  null
APPR_PLCY char 1  √  null
CUR_IND decimal 1  √  1
VER_NBR decimal 8  √  0
GRP_ID varchar 40  √  null
krim_grp_t
RQST_LBL varchar 255  √  null

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

Indexes:
Column(s) Type Sort
ACTN_RQST_ID Primary key Asc
DOC_HDR_ID Performance Asc
PRNCPL_ID Performance Asc
ACTN_TKN_ID Performance Asc
PARNT_ID Performance Asc
RSP_ID Performance Asc
STAT_CD + RSP_ID Performance Asc/Asc
RTE_NODE_INSTN_ID Performance Asc
STAT_CD + DOC_HDR_ID Performance Asc/Asc

Close relationships: