php - Database design ideas for order review

Question

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.

Answer 1

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.