Table products discount quantity

From Zen Cart(tm) Wiki
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!