This article outlines the database structure for the MMv4 ptcs_item_use database table.

• id
  Primary Key of the table.
  int(10) | unsigned | auto increment | primary key | indexed
  
• ptcs_item_id
  The id that references the individual ptcs_item.
  int(10) | unsigned | indexed
• cid
  The system ID (SID) number of the Customer in which placed the order via the UpSell or DownSell chain.
  int(10) | unsigned | indexed
• date
  Te date in which the order was placed or skipped via the ptcs system.
  int(10) | unsigned | indexed | timestamp
  
• ptcs_item_skipped
  This signifies if the customer chose to skip the UpSell/DownSell element within the chain
  int(10) | unsigned | indexed | timestamp
• order_record_type
  This specifies if the action taken after the order was placed via an Order or Declined (a Decline can occur due to a Payment related issue or error).
  int(10) | unsigned | indexed | Default: O
  
• order_record_id
  This records the specific SID of the Order or Decline respectfully.
  int(10) | unsigned | indexed
  
• order_item_id
  The system ID (SID) of the specific order_item associated with this UpSell/DownSell element in the chain.
  int(10) | unsigned | indexed