Table rice-2.1.1.krew_out_box_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_actn_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
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 6 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_OUT_BOX_ITM_TI1
DOC_HDR_ID Performance Asc KREW_OUT_BOX_ITM_TI2
ACTN_RQST_ID Performance Asc KREW_OUT_BOX_ITM_TI3

Close relationships: