Home  >  Q&A  >  body text

php - Database design ideas for order review

Currently we need to make an order review tool, which needs to review the information submitted by users from different places. If it passes, the points will be increased. If it fails, the points will not be increased or decreased, and this audit record must also be saved.

天蓬老师天蓬老师2722 days ago601

reply all(1)I'll reply

  • 黄舟

    黄舟2017-05-31 10:36:21

    One table records audit records, one table records orders, and one table records user information.
    Relationship:
    The order table and the audit record table are in a 1-to-1 relationship
    The user table and the order table are in a 1-to-n relationship, that is, one user can correspond to multiple orders.

    Increase points after passing the review, in the step of passing the review. Auditing and points auto-increment are the same transaction, so that’s fine.

    reply
    0
  • Cancelreply