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
|
