Table coupon gv queue

From Zen Cart(tm) Wiki
Jump to: navigation, search

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

unique_id

Indexed Fields

customer_id
order_id
release_flag


Columns

unique_id Primary Key

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 Index

Links the gift voucher to the customer that purchased it.
Type: int(5)
Null: No
Default: 0


order_id Index

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 Index

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.