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_pC
account_offsets.debit_id account_offsets_ibfk_fC
issue_id INT 10 √ null
borrowernumber INT 10 √ null
borrowers.borrowernumber accountlines_ibfk_borrowersN
itemnumber INT 10 √ null
items.itemnumber accountlines_ibfk_itemsN
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_typeR
debit_type_code VARCHAR 80 √ null
account_debit_types.code accountlines_ibfk_debit_typeR
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_2N
register_id INT 10 √ null
cash_registers.id accountlines_ibfk_registersN
interface VARCHAR 16 null
branchcode VARCHAR 10 √ null
branches.branchcode accountlines_ibfk_branchesN

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_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