Table products discount quantity

From Zen Cart(tm) Wiki
Revision as of 19:22, 14 September 2006 by Pencap (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Database Version

1.3.5


Description

Contains the information providing discounts based off of quantities.


Table Details

Primary Key

None.

Indexed Fields

products_id
discount_qty


Columns

discount_id

A sequence for each discount line starting at 1 for every product.
Type: int(4)
Null: No
Default: 0


products_id Index

Cross-reference link to the products table.
Type: int(11)
Null: No
Default: 0


discount_qty Index

The lowest quantity when this discount would start coming into effect.
Type: float
Null: No
Default: 0


discount_price

The price, price off or percent off for each product.
Type: decimal(15,4)
Null: No
Default: 0.0000
Info.png Information!
This field will know it is a price, price off or prcent off from the products_discount_type field in the products table.

Default Entries (assuming demo data installed)

TODO!