Im trying to create a messaging service in java which uses a mysql database, i have 2 tables a person table and a message table which consist of:

Table Person:
PersonId
Name

Table Message:
MessageId
SourceId
DestinationId
Subject
Message

PersonId and MessageId are both primary keys SourceId and DestinationId will both be the id of a person so what kind of relationship would this be?

Thanks in advanced.

foriegn key

one-to-many

Hi,

To make relationship to both database, I suggest you to add 'PersonId' in Table 'MessageId' as Foreign Key. After that you can handle both the table easily

this is, like, about the third thread recently where you just don't get what's going on

there already are ~two~ foreign keys to the person table in the message table