← Shopware 5.6.5

Shopware 5.6.5 s_order_documents

Generated order documents (invoices, delivery notes, credit notes) with file reference.

Columns

8 columns

Column Type Nullable Additional
id int(11) NO Primary Key, auto_increment
date date NO
type int(11) NO
userID int(11) NO Index
orderID int(11) unsigned NO Index
amount double NO
docID varchar(30) NO
hash varchar(255) NO

Indexes

3 indexes

Index Name Columns Unique
orderID orderID No
PRIMARY id Yes
userID userID No

Relations (to this table)

2 relations

Local Field Foreign Table Foreign Field
id s_mail_log_document document_id
id s_order_documents_attributes documentID