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
|
