On 11/23/05, Patrick Casey <[EMAIL PROTECTED]> wrote: > > > Ok, I admit it, this is probably a stupid question, but I can't > (curiously) seem to find an answer to this in the SQL spec.
I just looked more in details on your issue you have owning_id (foreign_key company(id)), foreign_key family(id))? Why do you have this as an id? I don't believe there is anything wrong of having in the table cars two foreign keys and where the column can be NULL. As an ID though, it doesn't make sense that they could be null. I don't believe so much in the one association table theory because then you end up with really lots of extra unecessary code to solve what is a very simple problem. We are actually not using any SQL foreign key constrain on our InnoDB... I let hibernate take care of the constraint. I find it getting too heavyweight with many foreign keys + hibernate. Henri. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
