OK, I'm working on a basic order database. The steps the order goes through are as follows:
1-Enter Order
2-Orders get staged to the warehouse for fulfillment
3-Warehouse workers fill the order (either complete or partial order
4-For orders that get delivered, it is possible that they can ship PARTIAL products ordered, so there needs to be a way to track partial shipments.
So I know I need an order table, an order detail table and then I need these other additional tables to track partial (or whole) shipments.
Suggestions?