Displaying 1 result from an estimated 1 matches for "users_raw".
2006 May 18
5
Overriding default DELETE behavior with logical deletes
...eally can''t physically delete almost
anything, because records must be kept for auditing and customer service
tracking purposes.
In the past, I''ve implemented logical deletes as follows:
1. Oracle implementation:
Each table that must implement logical deletes has a view, eg:
USERS_RAW => real table, has columns:
is_deleted(boolean,default false)
date_deleted(timestamp, default null)
USERS => is a view on USERS_RAW (where isdeleted = false)
Oracle allows updating such a view without any extra triggers, so from
RoR point of view this is compl...