vendor_edi_accounts


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
edifact_messages.edi_acct emfk_edi_acct C
description MEDIUMTEXT 16777215 null
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 MEDIUMTEXT 16777215 √ null
upload_directory MEDIUMTEXT 16777215 √ 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

Indexes

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

Relationships

Close relationships within degrees of separation