Table orders status history
From Zen Cart(tm) Wiki
Contents |
Database Version
- 1.3.5
Description
- Stores the individual updates to an order's status, as added by the Admin via the Admin > Customers > Orders page in the Admin panel.
Table Details
Primary Key
Indexed Fields
Columns
orders_status_history_id 
- A unique, auto incremented value, to identify each order status history record.
Type: int(11) Null: No Default: Extra: auto-increment
orders_id 
- Cross-reference link to the orders table.
Type: int(11) Null: No Default: 0
orders_status_id
- Cross-reference link to the orders_status table.
Type: int(5) Null: No Default: 0
date_added
- The date and time this record was added.
Type: datetime Null: No Default: 0001-01-01 00:00:00
customer_notified
- Was the customer notified by email of this update? Can be set to 0 (no) or 1 (yes),
Type: int(1) Null: Yes Default: 0
comments
- Comments (if any) that were added when the order status was updated.
Type: text Null: Yes Default: NULL
Default Entries
- None.
