Table testsql_comments.vendor_edi_accounts 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
id int 10  √ 
edifact_messages.edi_acct emfk_edi_acct C
fieldmapping.id Implied Constraint R
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.id vfk_vendor_id R
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.budget_id vfk_shipment_budget R
plugin varchar 256

Table contained 0 rows at Tue Dec 27 16:10 NZDT 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
shipment_budget Performance Asc shipmentbudget
vendor_id Performance Asc vendorid

Close relationships  within of separation: