Hacker News Reader

You could create a new table that keeps track of the logistics of the product. If the product is sent to supplier, a new row appears in this table with the date. If it hasn't been sent yet, no row is present.

View on HN

Handles the cases where an order had to be resent to the supplier better as well.

And when a supplier returns a shipment, and when new things happen that you haven’t thought of so a new column isn’t needed.

Reply on news.ycombinator.com