Could someone please show or describe to me how to implement soft deletes?
I have table of vouchers with these fields:
I want to display a given number of rows depending on the customer's request and once displayed they should be deleted so that the are not displayed again. (They are already invalid.)
I presume soft delete will ensure that no voucher is displayed twice. If you have any other idea on how I would do it I would appreciate.