From: JRStern@gte.net (JRStern)
Newsgroups: comp.databases.theory
Subject: Re: many-to-one relationship
Message-ID: <3b1e7984.12809098@news.gte.net>
References: <3B1084AA.3060902@ditdash.com>
X-Newsreader: Forte Free Agent 1.1/32.230
Lines: 12
X-Trace: /whjskjbVgF6AnO7BTyMn+RtdzKZV1ntiZ82t/aZG/fuUQbAGKJJTZkWEUyHQRMWeV0xQgmWIYe+!qgXfkYklUhpAOMNpX7IpIUCffaYcqtPPb0JATWKNGKNYD31AXBGaT3QIa5oPbIcS
X-Complaints-To: abuse@gte.net
X-Abuse-Info: Please be sure to forward a copy of ALL headers
X-Abuse-Info: Otherwise we will be unable to process your complaint properly
NNTP-Posting-Date: Wed, 06 Jun 2001 18:38:47 GMT
Distribution: world
Date: Wed, 06 Jun 2001 18:38:47 GMT


On Sun, 27 May 2001 04:40:23 GMT, Steve Croft <stevec@ditdash.com>
wrote:
>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.

Note table should use the PK from the referencing tables, if that's
what you mean by "id indicating the row", then you got it.

J.