Handle backorders in e commerce database design
I have a question relating to database design for an ecommerce. Almost everything works fine, but I need to handle backorder, which is the case when some products in an order from customer is currently out of stock, so these products will be put in a backorder.