| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| ID |
int |
11 |
|
√ |
|
|
|
| ACCOUNT_ID |
int |
11 |
|
|
|
|
| account.ACCOUNT_ID
|
customer_schedule_ibfk_1 |
|
| CUSTOMER_ID |
int |
11 |
|
|
|
|
| customer.CUSTOMER_ID
|
customer_schedule_ibfk_3 |
|
| CURRENCY_ID |
smallint |
6 |
√ |
|
null |
|
| currency.CURRENCY_ID
|
customer_schedule_ibfk_2 |
|
| ACTION_DATE |
date |
10 |
√ |
|
null |
|
|
| MISC_FEES |
decimal |
10,3 |
√ |
|
null |
|
|
| MISC_FEES_CURRENCY_ID |
smallint |
6 |
√ |
|
null |
|
|
| MISC_FEES_PAID |
decimal |
10,3 |
√ |
|
null |
|
|
| MISC_FEES_PAID_CURRENCY_ID |
smallint |
6 |
√ |
|
null |
|
|
| MISC_PENALTY |
decimal |
10,3 |
√ |
|
null |
|
|
| MISC_PENALTY_CURRENCY_ID |
smallint |
6 |
√ |
|
null |
|
|
| MISC_PENALTY_PAID |
decimal |
10,3 |
√ |
|
null |
|
|
| MISC_PENALTY_PAID_CURRENCY_ID |
smallint |
6 |
√ |
|
null |
|
|
| PAYMENT_STATUS |
smallint |
6 |
|
|
|
|
|
| INSTALLMENT_ID |
smallint |
6 |
|
|
|
|
|
| PAYMENT_DATE |
date |
10 |
√ |
|
null |
|
|
| PARENT_FLAG |
smallint |
6 |
√ |
|
null |
|
|
| VERSION_NO |
int |
11 |
|
|
|
|
|
Table contained 0 rows at Fri Dec 14 17:59 PST 2007
|
