| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| HISTORICAL_ID |
smallint |
6 |
|
√ |
|
|
|
| CUSTOMER_ID |
int |
11 |
|
|
|
|
| customer.CUSTOMER_ID
|
customer_historical_data_ibfk_1 |
|
| PRODUCT_NAME |
varchar |
100 |
√ |
|
null |
|
|
| LOAN_AMOUNT |
decimal |
10,3 |
√ |
|
null |
|
|
| LOAN_AMOUNT_CURRENCY_ID |
smallint |
6 |
√ |
|
null |
|
|
| TOTAL_AMOUNT_PAID |
decimal |
10,3 |
√ |
|
null |
|
|
| TOTAL_AMOUNT_PAID_CURRENCY_ID |
smallint |
6 |
√ |
|
null |
|
|
| INTEREST_PAID |
decimal |
10,3 |
√ |
|
null |
|
|
| INTEREST_PAID_CURRENCY_ID |
smallint |
6 |
√ |
|
null |
|
|
| MISSED_PAYMENTS_COUNT |
int |
11 |
√ |
|
null |
|
|
| TOTAL_PAYMENTS_COUNT |
int |
11 |
√ |
|
null |
|
|
| NOTES |
varchar |
500 |
√ |
|
null |
|
|
| LOAN_CYCLE_NUMBER |
int |
11 |
√ |
|
null |
|
|
| CREATED_BY |
smallint |
6 |
√ |
|
null |
|
|
| UPDATED_BY |
smallint |
6 |
√ |
|
null |
|
|
| CREATED_DATE |
date |
10 |
√ |
|
null |
|
|
| UPDATED_DATE |
date |
10 |
√ |
|
null |
|
|
| VERSION_NO |
int |
11 |
√ |
|
null |
|
|
Table contained 0 rows at Thu Dec 13 21:59 PST 2007
|
