Table rice-2.1.1.krew_app_doc_stat_tran_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
APP_DOC_STAT_TRAN_ID varchar 40
DOC_HDR_ID varchar 40  √  null
krew_doc_hdr_cntnt_t.DOC_HDR_ID Implied Constraint R
APP_DOC_STAT_FROM varchar 64  √  null
APP_DOC_STAT_TO varchar 64  √  null
STAT_TRANS_DATE datetime 19  √  null
VER_NBR decimal 8  √  0
OBJ_ID varchar 36

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

Indexes:
Column(s) Type Sort Constraint Name
APP_DOC_STAT_TRAN_ID Primary key Asc PRIMARY
DOC_HDR_ID + STAT_TRANS_DATE Performance Asc/Asc KREW_APP_DOC_STAT_TI1
DOC_HDR_ID + APP_DOC_STAT_FROM Performance Asc/Asc KREW_APP_DOC_STAT_TI2
DOC_HDR_ID + APP_DOC_STAT_TO Performance Asc/Asc KREW_APP_DOC_STAT_TI3
OBJ_ID Must be unique Asc KREW_APP_DOC_STAT_TRAN_TC0

Close relationships: