Database Examples/Pubs/Discounts

Fields

edit
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

edit
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