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 Comments
ACTN_RQST_ID varchar 40
krew_actn_itm_t.ACTN_RQST_ID Implied Constraint R
krew_out_box_itm_t.ACTN_RQST_ID Implied Constraint R
PARNT_ID varchar 40  √  null
ACTN_RQST_CD char 1
DOC_HDR_ID varchar 40
krew_doc_hdr_cntnt_t.DOC_HDR_ID Implied Constraint R
RULE_ID varchar 40  √  null
krms_rule_t.RULE_ID Implied Constraint R
STAT_CD char 1
RSP_ID varchar 40
krim_rsp_t.RSP_ID Implied Constraint R
PRNCPL_ID varchar 40  √  null
krim_prncpl_t.PRNCPL_ID Implied Constraint R
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.RTE_NODE_INSTN_ID Implied Constraint R
ACTN_TKN_ID varchar 40  √  null
krew_actn_tkn_t.ACTN_TKN_ID Implied Constraint R
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.GRP_ID Implied Constraint R
RQST_LBL varchar 255  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
ACTN_RQST_ID Primary key Asc PRIMARY
DOC_HDR_ID Performance Asc KREW_ACTN_RQST_T11
PRNCPL_ID Performance Asc KREW_ACTN_RQST_T12
ACTN_TKN_ID Performance Asc KREW_ACTN_RQST_T13
PARNT_ID Performance Asc KREW_ACTN_RQST_T14
RSP_ID Performance Asc KREW_ACTN_RQST_T15
STAT_CD + RSP_ID Performance Asc/Asc KREW_ACTN_RQST_T16
RTE_NODE_INSTN_ID Performance Asc KREW_ACTN_RQST_T17
STAT_CD + DOC_HDR_ID Performance Asc/Asc KREW_ACTN_RQST_T19

Close relationships: