Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I would like to log new products, updates to products and deletions of products (and the same for other schemata [customers, locations etc]).
Would it be best to have a separate table (e.g. ProductLog, CustomerLog) for this, so that I can have a product foreign key as a field in the ProductLog, customer foreign key in the Customer Log etc?
Or should I use one table to avoid creating essentially double the amount of tables?
When using MSSQL you can use temporal tables to track versions of your record.
See https://learn.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables
Yes I would use separate tables.
I worked in a company where we were doing the same for the exact same reason.
