discounts Table

The discount table contains the discount type, store ID, quantity, and percentage discount.

discounts is defined as:

create table discounts
(discounttype varchar(40) not null,
stor_id char(4) null
    references stores(stor_id),
lowqty smallint null,
highqty smallint null,
discount float not null)