MySQL Forums
Forum List  »  InnoDB

Re: Foreign Key problems
Posted by: Paul Reiser
Date: September 15, 2014 07:26AM

Hi Rick - I'm trying to do a simple genealogy, There are individual people, their parents, and sources of that information. I have a PEOPLE table, listing the person (INDI column) and the source (SOUR column), and then some information, and the listing of the parents PARE1 and PARE2, each of which match with some INDI in that same PEOPLE table. I can have multiple INDI's in the PEOPLE table corresponding to information on one individual but from different sources, but the (INDI,SOUR) pair will always define a unique row in the PEOPLE table. Then I have a SOURCES table, and the SOUR in the PEOPLE table points to a particular row in the SOURCES table, which gives info on that source.

Are you saying that I don't need to link these tables in any way? I guess that would mean I would not have to define any primary keys either?

Thanks for your help on this..
Paul

Options: ReplyQuote


Subject
Views
Written By
Posted
1759
September 12, 2014 10:46PM
924
September 13, 2014 09:18PM
952
September 14, 2014 02:39AM
960
September 14, 2014 01:15PM
1222
September 14, 2014 07:40PM
973
September 14, 2014 09:37PM
975
September 14, 2014 11:07PM
Re: Foreign Key problems
1034
September 15, 2014 07:26AM
1176
September 15, 2014 11:08AM
962
September 15, 2014 03:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.