Table rice-2.1.1.krew_actn_itm_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_ITM_ID varchar 40
krew_out_box_itm_t.ACTN_ITM_ID Implied Constraint R
PRNCPL_ID varchar 40
krim_prncpl_t.PRNCPL_ID Implied Constraint R
ASND_DT datetime 19
RQST_CD char 1
ACTN_RQST_ID varchar 40
krew_actn_rqst_t.ACTN_RQST_ID Implied Constraint R
DOC_HDR_ID varchar 40
krew_doc_hdr_cntnt_t.DOC_HDR_ID Implied Constraint R
ROLE_NM varchar 2000  √  null
DLGN_PRNCPL_ID varchar 40  √  null
DOC_HDR_TTL varchar 255  √  null
DOC_TYP_LBL varchar 128
DOC_HDLR_URL varchar 255
DOC_TYP_NM varchar 64
RSP_ID varchar 40
krim_rsp_t.RSP_ID Implied Constraint R
DLGN_TYP varchar 1  √  null
VER_NBR decimal 8  √  0
DTYPE varchar 50  √  null
GRP_ID varchar 40  √  null
krim_grp_t.GRP_ID Implied Constraint R
DLGN_GRP_ID varchar 40  √  null
RQST_LBL varchar 255  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
ACTN_ITM_ID Primary key Asc PRIMARY
PRNCPL_ID Performance Asc KREW_ACTN_ITM_T1
DOC_HDR_ID Performance Asc KREW_ACTN_ITM_TI2
ACTN_RQST_ID Performance Asc KREW_ACTN_ITM_TI3
PRNCPL_ID + DLGN_TYP + DOC_HDR_ID Performance Asc/Asc/Asc KREW_ACTN_ITM_TI5
DLGN_TYP + DLGN_PRNCPL_ID + DLGN_GRP_ID Performance Asc/Asc/Asc KREW_ACTN_ITM_TI6

Close relationships: