Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
accountlines_id | INT | 10 | √ | null |
|
|
|||||||||||
issue_id | INT | 10 | √ | null |
|
|
|||||||||||
old_issue_id | INT | 10 | √ | null |
|
|
|||||||||||
borrowernumber | INT | 10 | √ | null |
|
|
|||||||||||
itemnumber | INT | 10 | √ | null |
|
|
|||||||||||
date | TIMESTAMP | 19 | √ | null |
|
|
|||||||||||
amount | DECIMAL | 28,6 | √ | null |
|
|
|||||||||||
description | LONGTEXT | 2147483647 | √ | null |
|
|
|||||||||||
credit_type_code | VARCHAR | 80 | √ | null |
|
|
|||||||||||
debit_type_code | VARCHAR | 80 | √ | null |
|
|
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | accountlines_id |
accountlines_ibfk_issues | Performance | Asc | issue_id |
accountlines_ibfk_old_issues | Performance | Asc | old_issue_id |
accountlines_ibfk_registers | Performance | Asc | register_id |
acctsborridx | Performance | Asc | borrowernumber |
branchcode | Performance | Asc | branchcode |
credit_type_code | Performance | Asc | credit_type_code |
debit_type_code | Performance | Asc | debit_type_code |
itemnumber | Performance | Asc | itemnumber |
manager_id | Performance | Asc | manager_id |