Database Schema Question

From: Sébastien Boutté <boutte_at_wfinance.fr>
Date: Wed, 28 Aug 2002 10:46:08 +0200
Message-ID: <3d6c8de5$0$27142$afc38c87@news.easynet.fr>

Hi,

We are developing a 3 tiers architecture (GUI Java/Swing - J2EE WebLogic - IBM As/400)
and we have some questions about design of database.

Do we have to implement a physical delete for our system or keep everything ?
In case we implement a logical delete from GUI point of view, can we do that by adding a flag field on tables ? (We will have problems with unique constraints in this case.)

For these two questions, we would like to know what's done in reality for some big projects about "delete" implementation.

Thanks

Sebastien Boutte Received on Wed Aug 28 2002 - 03:46:08 CDT