Table rice-2.2.0-SNAPSHOT.krew_doc_hdr_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
DOC_HDR_ID varchar 40
krew_doc_hdr_cntnt_t.DOC_HDR_ID Implied Constraint R
DOC_TYP_ID varchar 40  √  null
krew_doc_typ_t.DOC_TYP_ID Implied Constraint R
DOC_HDR_STAT_CD char 1
RTE_LVL decimal 8
STAT_MDFN_DT datetime 19
CRTE_DT datetime 19
APRV_DT datetime 19  √  null
FNL_DT datetime 19  √  null
RTE_STAT_MDFN_DT datetime 19  √  null
TTL varchar 255  √  null
APP_DOC_ID varchar 255  √  null
DOC_VER_NBR decimal 8
INITR_PRNCPL_ID varchar 40
VER_NBR decimal 8  √  0
RTE_PRNCPL_ID varchar 40  √  null
DTYPE varchar 50  √  null
OBJ_ID varchar 36
APP_DOC_STAT varchar 64  √  null
APP_DOC_STAT_MDFN_DT datetime 19  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
DOC_HDR_ID Primary key Asc PRIMARY
APP_DOC_STAT Performance Asc KREW_DOC_HDR_T10
APP_DOC_STAT_MDFN_DT Performance Asc KREW_DOC_HDR_T12
OBJ_ID Must be unique Asc KREW_DOC_HDR_TC0
DOC_TYP_ID Performance Asc KREW_DOC_HDR_TI1
INITR_PRNCPL_ID Performance Asc KREW_DOC_HDR_TI2
DOC_HDR_STAT_CD Performance Asc KREW_DOC_HDR_TI3
TTL Performance Asc KREW_DOC_HDR_TI4
CRTE_DT Performance Asc KREW_DOC_HDR_TI5
RTE_STAT_MDFN_DT Performance Asc KREW_DOC_HDR_TI6
APRV_DT Performance Asc KREW_DOC_HDR_TI7
FNL_DT Performance Asc KREW_DOC_HDR_TI8
APP_DOC_ID Performance Asc KREW_DOC_HDR_TI9

Close relationships: