|
this article last updated: March 16, 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_payment database table.
- id
Primary Key of aff_payments table.
int(10) | unsigned | auto increment | primary key | indexed
- aff_id
The system ID number of the affiliate associated with the specific payment.
int(10) | unsigned | indexed
- date
The date of the payment
int(10) | 0/timestamp | indexed
- payment_id
The user defined Payment ID number
varchar(255) |indexed
- type
The type of payment, such as Credit Card, PayPal, etc.
varchar(255)| indexed
- value
The value of the payment.
double(16,2) | indexed
- memo
Payment memo.
text
|
