MMv4 KB
 
order_shipment DB Table
  Last Edited - 05/24/2010 1:24pm PDT
  Category Path - Developer's Guide > Database Structure
 
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

 

Powered by ModularKB