- FOREIGN KEY([quantity_id]) REFERENCES [Quantity]([id]),
- FOREIGN KEY([output_step_id]) REFERENCES [Step]([id]),
- FOREIGN KEY([input_step_id]) REFERENCES [Step]([id])
+ FOREIGN KEY([quantity_id]) REFERENCES [Quantity]([id]) ON DELETE CASCADE,
+ FOREIGN KEY([output_step_id]) REFERENCES [Step]([id]) ON DELETE CASCADE,
+ FOREIGN KEY([input_step_id]) REFERENCES [Step]([id]) ON DELETE CASCADE