Table db174.loan_activity_details Generated by
SchemaSpy
Implied relationships 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
ID int 11  √ 
loan_arrears_aging.ID Implied Constraint
CREATED_BY smallint 6
personnel.PERSONNEL_ID loan_activity_details_ibfk_1
ACCOUNT_ID int 11
account.ACCOUNT_ID loan_activity_details_ibfk_2
CREATED_DATE timestamp 19 CURRENT_TIMESTAMP
COMMENTS varchar 100
PRINCIPAL_AMOUNT decimal 10,3  √  null
PRINCIPAL_AMOUNT_CURRENCY_ID smallint 6  √  null
currency.CURRENCY_ID loan_activity_details_ibfk_3
INTEREST_AMOUNT decimal 10,3  √  null
INTEREST_AMOUNT_CURRENCY_ID smallint 6  √  null
currency.CURRENCY_ID loan_activity_details_ibfk_4
PENALTY_AMOUNT decimal 10,3  √  null
PENALTY_AMOUNT_CURRENCY_ID smallint 6  √  null
currency.CURRENCY_ID loan_activity_details_ibfk_6
FEE_AMOUNT decimal 10,3  √  null
FEE_AMOUNT_CURRENCY_ID smallint 6  √  null
currency.CURRENCY_ID loan_activity_details_ibfk_5
BALANCE_PRINCIPAL_AMOUNT decimal 10,3  √  null
BALANCE_PRINCIPAL_AMOUNT_CURRENCY_ID smallint 6  √  null
currency.CURRENCY_ID loan_activity_details_ibfk_7
BALANCE_INTEREST_AMOUNT decimal 10,3  √  null
BALANCE_INTEREST_AMOUNT_CURRENCY_ID smallint 6  √  null
currency.CURRENCY_ID loan_activity_details_ibfk_8
BALANCE_PENALTY_AMOUNT decimal 10,3  √  null
BALANCE_PENALTY_AMOUNT_CURRENCY_ID smallint 6  √  null
currency.CURRENCY_ID loan_activity_details_ibfk_9
BALANCE_FEE_AMOUNT decimal 10,3  √  null
BALANCE_FEE_AMOUNT_CURRENCY_ID smallint 6  √  null
currency.CURRENCY_ID loan_activity_details_ibfk_10

Table contained 0 rows at Tue Feb 26 10:59 PST 2008

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc PRIMARY
ACCOUNT_ID Performance Asc ACCOUNT_ID
BALANCE_FEE_AMOUNT_CURRENCY_ID Performance Asc BALANCE_FEE_AMOUNT_CURRENCY_ID
BALANCE_INTEREST_AMOUNT_CURRENCY_ID Performance Asc BALANCE_INTEREST_AMOUNT_CURRENCY_ID
BALANCE_PENALTY_AMOUNT_CURRENCY_ID Performance Asc BALANCE_PENALTY_AMOUNT_CURRENCY_ID
BALANCE_PRINCIPAL_AMOUNT_CURRENCY_ID Performance Asc BALANCE_PRINCIPAL_AMOUNT_CURRENCY_ID
CREATED_BY Performance Asc CREATED_BY
FEE_AMOUNT_CURRENCY_ID Performance Asc FEE_AMOUNT_CURRENCY_ID
INTEREST_AMOUNT_CURRENCY_ID Performance Asc INTEREST_AMOUNT_CURRENCY_ID
PENALTY_AMOUNT_CURRENCY_ID Performance Asc PENALTY_AMOUNT_CURRENCY_ID
PRINCIPAL_AMOUNT_CURRENCY_ID Performance Asc PRINCIPAL_AMOUNT_CURRENCY_ID

Close relationships  within one two degrees of separation :