Table rice-2.2.0-SNAPSHOT.krsb_msg_que_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
MSG_QUE_ID decimal 14 0
krsb_msg_pyld_t.MSG_QUE_ID Implied Constraint R
DT datetime 19
EXP_DT datetime 19  √  null
PRIO decimal 8
STAT_CD char 1
RTRY_CNT decimal 8
IP_NBR varchar 2000
SVC_NM varchar 255  √  null
APPL_ID varchar 255
SVC_MTHD_NM varchar 2000  √  null
APP_VAL_ONE varchar 2000  √  null
APP_VAL_TWO varchar 2000  √  null
VER_NBR decimal 8  √  0

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

Indexes:
Column(s) Type Sort Constraint Name
MSG_QUE_ID Primary key Asc PRIMARY
SVC_NM + SVC_MTHD_NM Performance Asc/Asc KRSB_MSG_QUE_TI1
APPL_ID + STAT_CD + IP_NBR + DT Performance Asc/Asc/Asc/Asc KRSB_MSG_QUE_TI2

Close relationships: