CREATE TABLE Transaction ( 
     OrderID SMALLINT UNSIGNED, 
    ProductID SMALLINT UNSIGNED, 
    Quantity TINYINT UNSIGNED CHECK(Quantity <= 100), 
    AmountSpent DECIMAL(6,2) UNSIGNED, 
    FOREIGN KEY(OrderID) REFERENCES Invoice(OrderID), 
    FOREIGN KEY(ProductID) REFERENCES Stock(ProductID)
);