Postgres Pro
Downloads
Home   >   mailing lists

Two relations from parent table to child table - Mailing list pgsql-novice

From JORGE MALDONADO
Subject Two relations from parent table to child table
Date
Msg-id CAAY=A78vcZWdsHS-x1buid6J3srRZPC4xBQDz6hmE513oJ8SZw@mail.gmail.com
Whole thread Raw
Responses Re: Two relations from parent table to child table
List pgsql-novice
Tree view
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.
Tables.jpg

Respectfully,
Jorge Maldonado
Attachment

pgsql-novice by date:

Previous
From: "Hilbert, Karin"
Date:
Subject: PostgreSQL database for GITLAB - Must it use the public schema?
Next
From: Andreas Kretschmer
Date:
Subject: Re: Two relations from parent table to child table