On Wed, Jan 22, 2014 at 12:08 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
What I would advise in this case is to organize deleted user IDs in a deletion queue. You do that by making a 'users to be deleted table' where you store the users pending deletion (which is the one and only thing that happens at trigger time). Then you set up batch process (say, via cron) that cleans out the data at a convenient time.
Agreed - Your active_status could have three statuses - Active, Inactive, and Deleted. The front end switches it to Inactive, and the cron job looks for all Inactive users, deletes their data and sets them to Deleted.