[Rt-devel] About data integrity rules
pgsql at j-davis.com
Mon Feb 11 12:23:15 EST 2008
On Fri, 2008-02-08 at 11:02 -0500, Jesse Vincent wrote:
> > The schema is really due for a good hard overhaul to allow the DB
> > engine to enforce data integrity as a second layer of protection which
> > the application tries to enforce.
> How would you model something like the "ObjectType/ObjectId" foriegn key
> on the Transactions or ACL table?
The relational model answer is that you store real world facts relevant
to your business in a database.
There is no business rule demanding "ObjectType/ObjectId". In the
real-world business, there are rules involving people, groups, tickets,
acls, history, etc. Therefore, a design in the spirit of the relational
model would start from those business rules.
More information about the Rt-devel