Table rice-2.2.0-SNAPSHOT.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
ACCT_NAME varchar 50  √  null
ACCT_TYPE varchar 100  √  null
ACCT_FO_ID decimal 14  √  null
trv_acct_fo.ACCT_FO_ID Implied Constraint 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 Fri May 10 14:36 PDT 2013


Close relationships: