MMv4 KB
 
order_item DB Table
  Last Edited - 07/30/2009 12:14pm PDT
  Category Path - Developer's Guide > Database Structure
 

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

 

 

Powered by ModularKB