|
this article last updated: May 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 basket database table.
- id
Primary Key of the table.
int(10) | unsigned | auto increment | primary key | indexed
- bid
The basket ID number, which is a random alphanumeric ID number assigned to the customer's shopping session.
varchar(255) | indexed
- pid
The product's system ID number.
int(10) | unsigned | indexed
- qty
The quantity of the product in the basket.
int(10)
- create_date
The Unix timestamp of the date and time the product was added to the basket.
int(10) | unsigned | indexed
- alt_price
The administrative override price that will be used instead of the price. This overrides the original price and any adjustments made to that price.
double(16,2)
- price_auth
The system id number of the admin who instituted the price override.
int(10) | unsigned
- cid
The customer's system ID number. The shipping address system ID number.
int(10) | unsigned | indexed
- sai
The shipping address system ID number.
int(10) | unsigned | indexed
- tid
The tracking ID number of the affiliate associated with the product.
int(10) | unsigned
- gift_wrap
The gift-wrap status of the product. Default is 0 = no gift wrap.
int(10) | unsigned | Values: 0/timestamp | Default: 0
- event_id
The system ID number of the event referenced with this basket entry..
int(10) | unsigned
|
