accountlines

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
accountlines_id INT 10 √ null
account_offsets.credit_id account_offsets_ibfk_p C
account_offsets.debit_id account_offsets_ibfk_f C
article_requests.debit_id article_requests_ibfk_5 N
issue_id INT 10 √ null
issues.issue_id accountlines_ibfk_issues N
old_issue_id INT 10 √ null
old_issues.issue_id accountlines_ibfk_old_issues N
borrowernumber INT 10 √ null
borrowers.borrowernumber accountlines_ibfk_borrowers N
itemnumber INT 10 √ null
items.itemnumber accountlines_ibfk_items N
date TIMESTAMP 19 √ null
amount DECIMAL 28,6 √ null
description LONGTEXT 2147483647 √ null
credit_type_code VARCHAR 80 √ null
account_credit_types.code accountlines_ibfk_credit_type R
debit_type_code VARCHAR 80 √ null
account_debit_types.code accountlines_ibfk_debit_type R
credit_number VARCHAR 20 √ null

autogenerated number for credits
status VARCHAR 16 √ null
payment_type VARCHAR 80 √ null

optional authorised value PAYMENT_TYPE
amountoutstanding DECIMAL 28,6 √ null
timestamp TIMESTAMP 19 current_timestamp()
note MEDIUMTEXT 16777215 √ null
manager_id INT 10 √ null
borrowers.borrowernumber accountlines_ibfk_borrowers_2 N
register_id INT 10 √ null
cash_registers.id accountlines_ibfk_registers N
interface VARCHAR 16 null
branchcode VARCHAR 10 √ null
branches.branchcode accountlines_ibfk_branches N

the branchcode of the library where a payment was made, a manual invoice created, etc.

Indexes

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
timeidx Performance Asc timestamp

Relationships

Close relationships within degrees of separation