this article last updated: May 24, 2010 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_shipment 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
- zone_fee_value
The total of zone fees associated with the shipment.
double(16,2) | indexed
- prod_add_ship_value
The total of products' additional shipping fees associated with the shipment.
double(16,2) | indexed
- ship_fee_value
The value of the shipping method associated with the shipment, prior to the addition of any zone fees and/or product-level additional shipping fees.
double(16,2) | indexed
- ship_method_id
Reference to the ship_method.id that this item is associated with.
int(10) | unsigned | indexed
|