Table orders status history

From Zen Cart(tm) Wiki
Revision as of 17:03, 8 September 2006 by Allcanadiansearch.ca (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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

orders_status_history_id

Indexed Fields

orders_id
orders_status_id


Columns

orders_status_history_id Primary Key

A unique, auto incremented value, to identify each order status history record.
Type: int(11)
Null: No
Default:
Extra: auto-increment


orders_id Index

Cross-reference link to the orders table.
Type: int(11)
Null: No
Default: 0


orders_status_id Index

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.