|
this article last updated: July 30, 2009 Due to inevitable changes that will be made to the shopping cart software over time, the cart's variable and database structure may change from time to time without advanced notice. We will attempt to keep the information in this article up-to-date, but Modular Merchant makes no guarantee as to the accuracy of the information provided in this article. Use this information at your own risk.
This article outlines the database structure for the MMv4 order_item database table.
- id
Primary Key of the table.
int(10) | unsigned | auto increment | primary key | indexed
- order_id
Reference to the order.id that this item is associated with.
int(10) | unsigned | indexed
- pid
Reference to the product.id that this item is associated with.
int(10) | unsigned | indexed
- qty
The number of this product contained in the order.
int(10) | unsigned | indexed
- price
The price actually paid for the product.
double(16,2)
- create_date
The date that this database item was created.
int(10) | unsigned | indexed
- ship_date
The date that the item was shipped.
int(10) | unsigned | indexed
- ship_method_id
The system ID of the shipping method associated with this order.
int(10) | unsigned | indexed
- gift_wrap
The item's gift-wrap status. 0 = not gift-wrapped; other value = gift-wrapped
int(10) | unsigned | Value: 0/timestamp | indexed
- event_id
The system ID of the store event this item is associated with.
int(10) | unsigned | indexed
- cogs
The COGS of a single unit of this product.
double(16,2)
- msrp
The MSRP of the product.
double(16,2)
- price_adj
The difference between the product's price in the store and the amount the customer paid for this item.
double(16,2) | indexed
|
