Shopware 5.7.7 s_order_history
Order status change history — audit log of payment and order state transitions.
| Column | Type | Nullable | Additional |
| id | int(11) | NO | Primary Key, auto_increment |
| orderID | int(11) | NO | Index |
| userID | int(11) | YES | Index |
| previous_order_status_id | int(11) | YES | Index |
| order_status_id | int(11) | YES | Index |
| previous_payment_status_id | int(11) | YES | Index |
| payment_status_id | int(11) | YES | Index |
| comment | text | NO | |
| change_date | datetime | YES | |
| Index Name | Columns | Unique |
| current_order_status | order_status_id | No |
| current_payment_status | payment_status_id | No |
| order | orderID | No |
| previous_order_status | previous_order_status_id | No |
| previous_payment_status | previous_payment_status_id | No |
| PRIMARY | id | Yes |
| user | userID | No |
