Table coupon redeem track
From Zen Cart(tm) Wiki
Contents |
Database Version
- 1.3.5
Description
- Stores information about redeemed coupons/gift vouchers.
Table Details
Primary Key
Indexed Fields
Columns
unique_id 
- A unique, auto incremented value, to identify each coupon redeem track entry.
Type: int(11) Null: No Default: Extra: auto_increment
coupon_id 
- 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.
