Column_name | 數(shù)據(jù)類型 | 可為空 | 默認值 | 檢查 | 鍵/索引 |
---|---|---|---|---|---|
discounttype | varchar(40) | 否 | |||
stor_id | char(4) | 是 | 外鍵 stores(stor_id) | ||
lowqty | smallint | 是 | |||
highqty | smallint | 是 | |||
discount | float | 否 |
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 |