Table coupon email track

From Zen Cart(tm) Wiki
Revision as of 12:24, 8 September 2006 by Allcanadiansearch.ca (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Database Version

1.3.5


Description

Stores all gift vouchers and coupons that have been sent via email.


Table Details

Primary Key

unique_id

Indexed Fields

coupon_id


Columns

unique_id Primary Key

A unique, auto incremented value, to identify each coupon email track record.
Type: int(11)
Null: No
Default:
Extra: auto_increment


coupon_id Foreign Key Index

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 Foreign Key

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.