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: Cyclical Relation.

Re: Cyclical Relation.

From: Steve Long <steven.long_at_erols.com>
Date: Tue, 24 Apr 2001 14:28:40 -0400
Message-ID: <9c4gpr$cma$1@bob.news.rcn.net>

from what you have indicated about what you are trying to do, i suggest you have User, SentTo, and Message tables. SentBy can be a FK column from Message to User.

"kk" <kk_at_tuputamadre.com> wrote in message news:3ae5971b$1_at_news...
> User UserMessage Message
> -------- ------------- --------
> IdUser IdMessage IdMessage
> Name IdUser ( who receives ) Date
> Active

 Title
>
> Body
>
> IdUser ( user who sent the message )
>
> There is a relation between User and Message 1:M when the user writes a
> message.
> There is a relation between User and Message M:M when the user receives a
> message.
> Can be this a solution??.
>
> Regards..
>
>
>
Received on Tue Apr 24 2001 - 13:28:40 CDT

Original text of this message

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