Addedorders.parent_order_idUsed for (a) decomposing previous orders by breaking the parent order into smaller orders OR (b) linking a previous order to a resale order.
Addedorder.is_resale*, to indicate that an order is a resale of previous order. parent_id will reference the originating order MOST RECENT:*