diff --git a/BDL/BDL_schema.sql b/BDL/BDL_schema.sql index dc5c0b6..c0d4069 100644 --- a/BDL/BDL_schema.sql +++ b/BDL/BDL_schema.sql @@ -313,7 +313,7 @@ Price NUMBER(6,2) NOT NULL CONSTRAINT Order_Line_Price_Too_Low CHECK ( Price BETWEEN 0 AND 9999.99 ), -- - Qty_Received NUMBER(6) NOT NULL + Qty_Received NUMBER(5) NOT NULL CONSTRAINT Order_Line_Qty_Rec_Too_Low CHECK ( Qty_Received >= 0 ), -- CONSTRAINT Order_Line_PK PRIMARY KEY ( Order_Num, Component_Code ),