| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| accountlines_id |
int |
10 |
|
√ |
|
|
|
| issue_id |
int |
10 |
√ |
|
null |
|
| issues.issue_id
|
Implied Constraint R |
|
| borrowernumber |
int |
10 |
|
|
0 |
|
| borrowers.borrowernumber
|
accountlines_ibfk_1 C |
|
| accountno |
smallint |
5 |
|
|
0 |
|
|
| itemnumber |
int |
10 |
√ |
|
null |
|
| items.itemnumber
|
accountlines_ibfk_2 N |
|
| date |
date |
10 |
√ |
|
null |
|
|
| amount |
decimal |
28,6 |
√ |
|
null |
|
|
| description |
longtext |
2147483647 |
√ |
|
null |
|
|
| dispute |
longtext |
2147483647 |
√ |
|
null |
|
|
| accounttype |
varchar |
5 |
√ |
|
null |
|
|
| payment_type |
varchar |
80 |
√ |
|
null |
|
|
| amountoutstanding |
decimal |
28,6 |
√ |
|
null |
|
|
| lastincrement |
decimal |
28,6 |
√ |
|
null |
|
|
| timestamp |
timestamp |
19 |
|
|
CURRENT_TIMESTAMP |
|
|
| note |
mediumtext |
16777215 |
√ |
|
null |
|
|
| manager_id |
int |
10 |
√ |
|
null |
|
|
Table contained 0 rows at Mon Jul 16 08:37 NZST 2018
|
