I'm using Postgresql DB. I read the Wikipedia article about referential integrity but I still can't understand why we are obliged to keep deleted users in the "users" table. Even in the case of referential integrity we can delete all entries related to the deleted "userId" in all tables. Not ?
There's a lot of disadvantages when keeping absolute entries in a such important table in DB. This is a preliminary administration task and I think that all meetings and activities created by a deleted user must be deleted too.
<<608-1041a.jpg>>
