Database Examples/Pubs/Discounts

Fields

Field Name	Field Type	Length	Index	Constraint	Default
discountid	Integer		Primary Key	Not Null
discounttype	Text	40	Yes	Not Null
stor_id	Integer		Yes	Foreign Key
lowqty	Integer
highqty	Integer
discount	Decimal			>=0

Data

discountid	discounttype	stor_id	lowqty	highqty	discount
1	Initial Customer				10.50
2	Volume Discount		100	1000	6.7
3	Customer Discount	8042			5.0