|
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 gift_cert database table.
- id
Primary Key of the table.
int(10) | unsigned | auto increment | primary key | indexed
- event_id
Reference to the event_info .id that this item is associated with.
int(10) | unsigned | indexed
- create_date
The date in which this gift certificate was created.
int(10) | unsigned | indexed | 0/timestamp
- sender_cid
Reference to the customer.id this gift certificate was sent from.
int(10) | unsigned | indexed
- sender_name
The name of the sender for this gift certificate.
varchar(255) | indexed
- recip_name
The name of the recipient for this gift certificate.
varchar(255) | indexed
- recip_email
The email address of the recipient for this gift certificate.
varchar(255) | indexed
- message
The custom message in which will be sent to the recipient for this gift certificate.
text
|
