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