Table testsql_comments.accountlines Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
accountlines_id int 10  √ 
issue_id int 10  √  null
borrowernumber int 10 0
borrowers
accountno smallint 5 0
itemnumber int 10  √  null
items
date date 10  √  null
amount decimal 28,6  √  null
description mediumtext 16777215  √  null
dispute mediumtext 16777215  √  null
accounttype varchar 5  √  null
amountoutstanding decimal 28,6  √  null
lastincrement decimal 28,6  √  null
timestamp timestamp 19 CURRENT_TIMESTAMP
notify_id int 10 0
notify_level int 10 0
note text 65535  √  null
manager_id int 10  √  null

Table contained 0 rows at Tue Dec 27 17:18 NZDT 2016

Indexes:
Column(s) Type Sort
accountlines_id Primary key Asc
borrowernumber Performance Asc
itemnumber Performance Asc
timestamp Performance Asc

Close relationships  within of separation: