| 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 |
mediumtext |
16777215 |
√ |
|
null |
|
|
| dispute |
mediumtext |
16777215 |
√ |
|
null |
|
|
| accounttype |
varchar |
5 |
√ |
|
null |
|
|
| amountoutstanding |
decimal |
28,6 |
√ |
|
null |
|
|
| lastincrement |
decimal |
28,6 |
√ |
|
null |
|
|
| timestamp |
timestamp |
19 |
|
|
CURRENT_TIMESTAMP |
|
|
| notify_id |
int |
10 |
|
|
0 |
|
|
| notify_level |
int |
10 |
|
|
0 |
|
|
| note |
text |
65535 |
√ |
|
null |
|
|
| manager_id |
int |
10 |
√ |
|
null |
|
|
Table contained 0 rows at Mon Jun 26 10:02 NZST 2017
|
