This article outlines the database structure for the MMv4 ptcs database table.
- id
Primary Key of the table.
int(10) | unsigned | auto increment | primary key | indexed
- display_order
The order in which the UpSell / DownSell chain will be displayed in the storefront.
int(10) | unsigned | indexed
- active
If this field contains a value greater than zero, then the UpSell/DownSell chain is active.
int(10) | unsigned | indexed
- name
This is the name of the UpSell/DownSell chain, this name is only visable to store admin; customers will never see this name.
varcahr(255) | indexed
- current_thread
The system ID (SID) of the current thread of rules to be used in the next order that trigger's this specific UpSell/DownSell chain.
int(10) | unsigned | indexed
|