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