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?
Asked by Basil
(131 rep)
Jan 27, 2023, 03:29 PM
Last activity: Jun 4, 2025, 06:03 PM
Last activity: Jun 4, 2025, 06:03 PM