|
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 aff_commission database table.
- id
Primary Key of aff_commission table.
int(10) | unsigned | auto increment | primary key | indexed
- tid
Tracking ID number that is referenced for the specific commission; commissions are tracked by the tid.
int(10) | unsigned | indexed
- date
This is the date in which the commission was recorded by either an order or by a store admin
int(10) | unsigned | indexed | timestamp
- order_id
The Order ID referenced for this commision.
int(10) | unsigned | indexed
- value
The value of the commission that was awarded to the affiliate for the sale.
double(16,2)| unsigned | indexed
- type
The type of the commission.
int(10) | unsigned | indexed | values: sales commission or manual commission
|
