diff --git a/BDL/BDL_schema.sql b/BDL/BDL_schema.sql index c0d4069..286819f 100644 --- a/BDL/BDL_schema.sql +++ b/BDL/BDL_schema.sql @@ -247,7 +247,7 @@ Product_Code NUMBER(8), -- Quantity NUMBER(4) NOT NULL - CONSTRAINT Sale_Line_Quantity_Too_Low CHECK ( Quantity > 0 ), + CONSTRAINT Sale_Line_Quantity_Too_Low CHECK ( Quantity BETWEEN 1 AND 9999 ), -- Actual_Price NUMBER(7,2) NOT NULL CONSTRAINT Sale_Line_Act_Price_Too_Low CHECK ( Actual_Price BETWEEN 0 AND 99999.99 ),