Table coupon gv queue
From Zen Cart(tm) Wiki
Contents |
Database Version
- 1.3.6
Description
- Stores all the coupons/gift vouchers in a que that need to be approved for delivery through the admin.
Table Details
Primary Key
Indexed Fields
Columns
unique_id 
- A unique, auto incremented value, to identify each coupon/gift voucher stored in the queue.
Type: int(5) Null: No Default: Extra: auto_increment
customer_id 
- Links the gift voucher to the customer that purchased it.
Type: int(5) Null: No Default: 0
order_id
- Links the gift voucher to the order that it was purchased on.
Type: int(5) Null: No Default: 0
amount
- The amount of the specific gift voucher/coupon in the queue.
Type: decimal(15,4) Null: No Default: 0.0000
date_created
- The date and time that the record was created.
Type: datetime Null: No Default: 0001-01-01 00:00:00
ipaddr
- The ip address of the computer that created the record.
Type: varchar(32) Null: No Default:
release_flag
- Has/can the coupon/gift voucher be released to the customer? Can be set to N (no) or Y (yes).
Type: char(1) Null: No Default: N
Default Entries
- None.
