Two relations from parent table to child table
JORGE MALDONADO <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.novice |
|---|---|
| Message-ID | <CAAY=A78vcZWdsHS-x1buid6J3srRZPC4xBQDz6hmE513oJ8SZw@mail.gmail.com> |
Hi, I have a table of games and a catalog of teams where each game is always played by 2 teams. How should I design these tables? Please refer to the image below. I suppose that option #2 is the correct one but I want to make sure it is. I have never seen 2 relations from a parent table to a child table. [image: Tables.jpg] Respectfully, Jorge Maldonado
Tables.jpg
(image/jpeg, 50 KB) - not displayed