| 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 |