Two relations from parent table to child table

From: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Two relations from parent table to child table
Date: 2019-01-22 01:07:28
Message-ID: CAAY=A78vcZWdsHS-x1buid6J3srRZPC4xBQDz6hmE513oJ8SZw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2019-01-22 05:43:45 Re: Two relations from parent table to child table
Previous Message Hilbert, Karin 2019-01-21 15:25:38 PostgreSQL database for GITLAB - Must it use the public schema?