accountlines


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
issue_id INT 10 √ null
borrowernumber INT 10 √ null
borrowers.borrowernumber accountlines_ibfk_borrowers N
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
accounttype VARCHAR 5 √ null
payment_type VARCHAR 80 √ null

optional authorised value PAYMENT_TYPE
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

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc accountlines_id
acctsborridx Performance Asc borrowernumber
itemnumber Performance Asc itemnumber
timeidx Performance Asc timestamp

Relationships

Close relationships within degrees of separation