What should we call a table that stores changes to another table? At the moment, we have a Persons Table. But we also need another table to store changes made to that Persons Table. But, my question is, what naming convention is used for tables that store changes made to other database tables.
In our company, we use to suffix the table name with _history. So, for the persons table you might have a table named persons_history.