This change would be very helpful! I would vote for the first option -- adding a "deleted" column to both tables and retaining the historical data.
This change would be very helpful! I would vote for the first option -- adding a "deleted" column to both tables and retaining the historical data.