locked
Database Design: Sales Order & Purchase Order RRS feed

  • Question

  • I found the inventory tables of the "Purchase Order" tables is very similar to the "Sales Order" tables.  Is it logical to have a design such that PO and SO share the SAME table?  (e.g. use a flag to determine if it's SO / PO)

    For example,

    SALES ORDER
    - sales_order
    - sales_order_items

    PURCHASE ORDER
    - purchase_order
    - purchase_order_items

    ORDER <----- combine SALES ORDER & PURCHASE ORDER
    - order
    - order_items

    Please help ~~

    Wednesday, May 28, 2014 7:38 AM

Answers

All replies