Table testsql_comments.accountlines Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
accountlines_id int 10  √ 
account_offsets.credit_id account_offsets_ibfk_p C
account_offsets.debit_id account_offsets_ibfk_f C
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 longtext 2147483647  √  null
dispute 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 at Mon Jul 16 08:37 NZST 2018

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

Close relationships  within of separation: