Database Examples/Pubs/Discounts

< Database Examples < Pubs

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
This article is issued from Wikiversity. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.