discounts

Transact-SQL Reference

Transact-SQL Reference

discounts

Column_name Data type Nullable Default Check Key/index
discounttype varchar(40) no
stor_id char(4) yes FK stores(stor_id)
lowqty smallint yes
highqty smallint yes
discount float no

  

discounttype stor_id lowqty highqty discount
Initial Customer NULL NULL NULL 10.5
Volume Discount NULL 100 1000 6.7
Customer Discount 8042 NULL NULL 5.0