|
this article last updated: January 19, 2010 Due to inevitable changes that will be made to the shopping cart software over time, the cart's variable and database structure may change from time to time without advanced notice. We will attempt to keep the information in this article up-to-date, but Modular Merchant makes no guarantee as to the accuracy of the information provided in this article. Use this information at your own risk.
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
|
