Table rice-2.1.1.trv_acct 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
ACCT_NUM varchar 10
trav_doc_2_accounts.ACCT_NUM Implied Constraint R
trv_acct_ext.ACCT_NUM Implied Constraint R
trv_acct_use_rt_t.ACCT_NUM Implied Constraint R
trv_doc_acct.ACCT_NUM Implied Constraint R
ACCT_NAME varchar 50  √  null
ACCT_TYPE varchar 100  √  null
ACCT_FO_ID decimal 14  √  null
trv_acct_fo.ACCT_FO_ID TRV_ACCT_FK1 R
OBJ_ID varchar 36  √  null
VER_NBR decimal 8  √  0
SUB_ACCT varchar 10  √  null
SUB_ACCT_NAME varchar 50  √  null
CREATE_DT datetime 19  √  null
SUBSIDIZED_PCT float 12  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
ACCT_NUM Primary key Asc PRIMARY
ACCT_FO_ID Performance Asc TRV_ACCT_FK1

Close relationships: