vendor_edi_accounts

0 rows


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 MEDIUMTEXT 16777215 √ NULL
upload_port INT 10 √ NULL
download_port INT 10 √ 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
standard VARCHAR 3 √ 'EUR'
id_code_qualifier VARCHAR 3 √ '14'
transport VARCHAR 6 √ 'FTP'
quotes_enabled TINYINT 3 0
invoices_enabled TINYINT 3 0
orders_enabled TINYINT 3 0
responses_enabled TINYINT 3 0
auto_orders TINYINT 3 0
shipment_budget INT 10 √ NULL
aqbudgets.budget_id vfk_shipment_budget R
plugin VARCHAR 256 ''

Indexes

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

Relationships

Close relationships within degrees of separation