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
|