Difference between revisions of "Table coupon gv queue"

From Zen Cart(tm) Wiki
Jump to: navigation, search
(1.3.6)
Line 1: Line 1:
{{Template:menuBarDevelopers}}
 
== 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 ===
 
:[[Table coupon_gv_queue#unique_id|unique_id]]
 
 
=== Indexed Fields ===
 
:[[Table coupon_gv_queue#customer_id|customer_id]]
 
:[[Table coupon_gv_queue#order_id|order_id]]
 
:[[Table coupon_gv_queue#release_flag|release_flag]]
 
 
 
== Columns ==
 
=== unique_id [[Image:Primary_key.gif|Primary Key]]===
 
:A unique, auto incremented value, to identify each coupon/gift voucher stored in the queue.
 
<BLOCKQUOTE>
 
{|
 
| Type: || int(5)
 
|-
 
| Null: || No
 
|-
 
| Default: ||
 
|-
 
| Extra: || auto_increment
 
|}
 
</BLOCKQUOTE>
 
 
 
=== customer_id [[Image:Index.gif|Index]]===
 
:Links the gift voucher to the customer that purchased it.
 
<BLOCKQUOTE>
 
{|
 
| Type: || int(5)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0
 
|}
 
</BLOCKQUOTE>
 
 
 
=== order_id [[Image:Index.gif|Index]]===
 
:Links the gift voucher to the order that it was purchased on.
 
<BLOCKQUOTE>
 
{|
 
| Type: || int(5)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0
 
|}
 
</BLOCKQUOTE>
 
 
 
=== amount ===
 
:The amount of the specific gift voucher/coupon in the queue.
 
<BLOCKQUOTE>
 
{|
 
| Type: || decimal(15,4)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0.0000
 
|}
 
</BLOCKQUOTE>
 
 
 
=== date_created ===
 
:The date and time that the record was created.
 
<BLOCKQUOTE>
 
{|
 
| Type: || datetime
 
|-
 
| Null: || No
 
|-
 
| Default: || 0001-01-01 00:00:00
 
|}
 
</BLOCKQUOTE>
 
 
 
=== ipaddr ===
 
:The ip address of the computer that created the record.
 
<BLOCKQUOTE>
 
{|
 
| Type: || varchar(32)
 
|-
 
| Null: || No
 
|-
 
| Default: ||
 
|}
 
</BLOCKQUOTE>
 
 
 
=== release_flag [[Image:Index.gif|Index]]===
 
:Has/can the coupon/gift voucher be released to the customer? Can be set to ''N'' (no) or ''Y'' (yes).
 
<BLOCKQUOTE>
 
{|
 
| Type: || char(1)
 
|-
 
| Null: || No
 
|-
 
| Default: || N
 
|}
 
</BLOCKQUOTE>
 
 
 
== Default Entries ==
 
:None.
 

Revision as of 00:37, 5 December 2007