|
this article last updated: May 24, 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 subscription database table.
- id
Primary Key of rec_order table.
int(10) | unsigned | auto increment | primary key | indexed
- cid
A reference to the customer.id field associated with this scheduled order record.
int(10) | unsigned | indexed
- cc_id
A reference to the customer_ref.id field associated with this scheduled order record.
int(10) | unsigned | indexed
- tid
A reference to the affiliate's tracking id associated with this scheduled order record.
int(10) | unsigned | indexed
- retain_tid
Whether or not the affiliate TID is retained for future rebilling cycles.
int(10) | unsigned | indexed
- gateway
The payment gateway used to process this scheduled order.
varchar(255) | indexed
- coupon_codes
Any coupon codes that are associated with this scheduled order.
varchar(255) | indexed
- retain_coupons
If the value in this field is greater than 0, the coupon codes are retained after this scheduled order is run.
int(10) | unsigned | Values: 0/timestamp | indexed
|
