--- On Fri, 1/11/08, David Fetter <david@xxxxxxxxxx> wrote:
> > One method
> > that has been proposed is to have a third table which
> stores to what object
> > type a comment belongs, but I don't like this
> because the foreign key
> > relationships then wouldn't be maintained by the
> database. The only way
> > that I'm able to think of at the moment is
> multiple columns.
Actually, I think if you notice the example I posted previously, I made both the Unique ID column and object type column a composite primary key.
The other tables referenced this composite primary key as foreign keys using referential integrity ON UPDATE CASCADE. This means that they database ~would~ maintain/enforce the object-type portion of the foreign key automatically for you.
Regards,
Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
