It’s a good question, but if you care about the audit trail, then perhaps event sourcing is a better choice.
So yes, this only assumes you care about when the on state happened and you don’t care about the history.
So yes, this only assumes you care about when the on state happened and you don’t care about the history.
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.