Table db176.financial_trxn Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
TRXN_ID int 10  √ 
financial_trxn.RELATED_FIN_TRXN financial_trxn_ibfk_6
ACCOUNT_TRXN_ID int 10
account_trxn.ACCOUNT_TRXN_ID financial_trxn_ibfk_1
RELATED_FIN_TRXN int 10  √  null
financial_trxn.TRXN_ID financial_trxn_ibfk_6
CURRENCY_ID smallint 5  √  null
currency.CURRENCY_ID financial_trxn_ibfk_5
FIN_ACTION_ID smallint 5  √  null
financial_action.FIN_ACTION_ID financial_trxn_ibfk_7
GLCODE_ID smallint 5
gl_code.GLCODE_ID financial_trxn_ibfk_9
POSTED_AMOUNT decimal 10,3
POSTED_AMOUNT_CURRENCY_ID smallint 5  √  null
currency.CURRENCY_ID financial_trxn_ibfk_3
BALANCE_AMOUNT decimal 10,3
BALANCE_AMOUNT_CURRENCY_ID smallint 5  √  null
currency.CURRENCY_ID financial_trxn_ibfk_4
ACTION_DATE date 0
POSTED_DATE date 0
POSTED_BY smallint 5  √  null
personnel.PERSONNEL_ID financial_trxn_ibfk_8
ACCOUNTING_UPDATED smallint 5  √  null
NOTES varchar 200  √  null
DEBIT_CREDIT_FLAG smallint 5

Table contained 0 rows at Tue Mar 04 15:50 PST 2008

Indexes:
Column(s) Type Sort Constraint Name
TRXN_ID Primary key Asc PRIMARY
ACCOUNT_TRXN_ID Performance Asc ACCOUNT_TRXN_ID
BALANCE_AMOUNT_CURRENCY_ID Performance Asc BALANCE_AMOUNT_CURRENCY_ID
CURRENCY_ID Performance Asc CURRENCY_ID
FIN_ACTION_ID Performance Asc FIN_ACTION_ID
GLCODE_ID Performance Asc GLCODE_ID
POSTED_AMOUNT_CURRENCY_ID Performance Asc POSTED_AMOUNT_CURRENCY_ID
POSTED_BY Performance Asc POSTED_BY
RELATED_FIN_TRXN Performance Asc RELATED_FIN_TRXN

Close relationships  within one two degrees of separation :