Table coupon email track
From Zen Cart(tm) Wiki
Contents |
Database Version
- 1.3.5
Description
- Stores all gift vouchers and coupons that have been sent via email.
Table Details
Primary Key
Indexed Fields
Columns
unique_id 
- A unique, auto incremented value, to identify each coupon email track record.
Type: int(11) Null: No Default: Extra: auto_increment
coupon_id 
- Links the coupon email track record to a unique coupon id in the coupons table. Foreign key to coupons.coupons_id.
Type: int(11) Null: No Default: 0
customer_id_sent
- Links the coupon email track record to a unique customer id in customers table. Foreign key to customers.customers_id.
Type: int(11) Null: No Default: 0
sent_firstname
- The coupon recipient's first name.
Type: varchar(32) Null: Yes Default: NULL
sent_lastname
- The coupon recipient's last name.
Type: varchar(32) Null: Yes Default: NULL
emailed_to
- The coupon recipient's email address.
Type: varchar(32) Null: Yes Default: NULL
date_sent
- The date and time that the email was sent.
Type: datetime Null: No Default: 0001-01-01 00:00:00
Default Entries
- None.
