Table coupon redeem track

From Zen Cart(tm) Wiki
Revision as of 12:26, 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 information about redeemed coupons/gift vouchers.


Table Details

Primary Key

unique_id

Indexed Fields

coupon_id


Columns

unique_id Primary Key

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


coupon_id Index

Links the specific coupon redeem track record to the actual coupon in the coupons table.
Type: int(11)
Null: No
Default: 0


customer_id

Links the specific coupon redeem track record to the customer that owns it in the customers table.
Type: int(11)
Null: No
Default: 0


redeem_date

The date and time that the coupon/gift voucher was redeemed.
Type: datetime
Null: No
Default: 0001-01-01 00:00:00


redeem_ip

The ip address of the computer that the coupon/gift voucher was redeemed from.
Type: varchar(32)
Null: No
Default:


order_id

Links the coupon/gift voucher to the order it was used on from the orders table.
Type: int(11)
Null: No
Default: 0


Default Entries

None.