many-to-one relationship

From: Steve Croft <stevec_at_ditdash.com>
Date: Sun, 27 May 2001 04:40:23 GMT
Message-ID: <3B1084AA.3060902_at_ditdash.com>


I am having a rather sticky modeling problem. We have a number of different tables, rows of which may have zero, one or more notes attached. A note table has a type id indicating the table, and an id indicating the row in that particular table.

I suspect there is a better way to do this - is there? If not, how do you diagram it?

   I'm sure it's an obvious answer but I'm not seeing it :(

Thanks in advance,
Steve Received on Sun May 27 2001 - 06:40:23 CEST

Original text of this message