[Rt-devel] About data integrity rules

Jeff Davis 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.

Regards,
	Jeff Davis



More information about the Rt-devel mailing list