Table testsql_comments.vendor_edi_accounts 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
id int 10  √ 
edifact_messages
description text 65535
host varchar 40  √  null
username varchar 40  √  null
password varchar 40  √  null
last_activity date 10  √  null
vendor_id int 10  √  null
aqbooksellers
download_directory text 65535  √  null
upload_directory text 65535  √  null
san varchar 20  √  null
id_code_qualifier varchar 3  √  14
transport varchar 6  √  FTP
quotes_enabled bit 0 0
invoices_enabled bit 0 0
orders_enabled bit 0 0
responses_enabled bit 0 0
auto_orders bit 0 0
shipment_budget int 10  √  null
aqbudgets
plugin varchar 256

Table contained 0 rows at Mon Jun 26 10:02 NZST 2017

Indexes:
Column(s) Type Sort
id Primary key Asc
shipment_budget Performance Asc
vendor_id Performance Asc

Close relationships  within of separation: