| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| ACCOUNT_TRXN_ID |
int |
11 |
|
|
|
|
| account_trxn.ACCOUNT_TRXN_ID
|
customer_loan_account_detail_ibfk_1 |
|
| ACCOUNT_ID |
int |
11 |
|
|
|
|
|
| CURRENCY_ID |
smallint |
6 |
√ |
|
null |
|
| currency.CURRENCY_ID
|
customer_loan_account_detail_ibfk_2 |
|
| INSTALLMENT_NUMBER |
smallint |
6 |
|
|
|
|
|
| DUE_DATE |
date |
10 |
|
|
|
|
|
| PRINCIPAL |
decimal |
10,3 |
|
|
|
|
|
| PRINCIPAL_CURRENCY_ID |
smallint |
6 |
|
|
|
|
| currency.CURRENCY_ID
|
customer_loan_account_detail_ibfk_3 |
|
| INTEREST |
decimal |
10,3 |
|
|
|
|
|
| INTEREST_CURRENCY_ID |
smallint |
6 |
|
|
|
|
| currency.CURRENCY_ID
|
customer_loan_account_detail_ibfk_4 |
|
| PENALTY |
decimal |
10,3 |
|
|
|
|
|
| PENALTY_CURRENCY_ID |
smallint |
6 |
|
|
|
|
| currency.CURRENCY_ID
|
customer_loan_account_detail_ibfk_5 |
|
Table contained 0 rows at Sat Nov 10 18:16 PST 2007
|
