Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: many-to-one relationship

Re: many-to-one relationship

From: JRStern <JRStern_at_gte.net>
Date: Wed, 06 Jun 2001 18:38:47 GMT
Message-ID: <3b1e7984.12809098@news.gte.net>

On Sun, 27 May 2001 04:40:23 GMT, Steve Croft <stevec_at_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. Received on Wed Jun 06 2001 - 13:38:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US