Eventsourcing is a possible solution for audit trails but comes with additional complexity. If you just want to add audits of what changed when then you can al

Eventsourcing is a possible solution for audit trails but comes with additional complexity. If you just want to add audits of what changed when then you can also get there with a separate audit table that just stores timeframe, changed fields with new values and who/what made the change. Some frameworks have support for this out of the box or with a small library.