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
|
