Shopware 5.5.7 s_order_documents
Generated order documents (invoices, delivery notes, credit notes) with file reference.
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
| Index Name | Columns | Unique |
|---|---|---|
| orderID | orderID | No |
| PRIMARY | id | Yes |
| userID | userID | No |
Relations (to this table)
| Local Field | Foreign Table | Foreign Field |
|---|---|---|
| id | s_order_documents_attributes | documentID |