MIME-Version: 1.0
From: JORGE MALDONADO <jorgemal1960@gmail.com>
Date: Mon, 2 Oct 2023 15:57:32 -0500
Message-ID: 
 <CAAY=A7_wHBKkKFxuxXc7A+fr3TYGmWS9-hCGghLRDcQAAa_wfQ@mail.gmail.com>
Subject: A situation with one parent table and 3 child tables
To: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000a23af00606c206b1"
Archived-At: 
 <https://www.postgresql.org/message-id/CAAY%3DA7_wHBKkKFxuxXc7A%2Bfr3TYGmWS9-hCGghLRDcQAAa_wfQ%40mail.gmail.com>
Precedence: bulk

--000000000000a23af00606c206b1
Content-Type: text/plain; charset="UTF-8"

Hi,

I have one parent table (*table_p*) with 3 child tables (*table_ch1*,
*table_ch2
*and *table_ch3*). Each record of the parent table can be associated with 1
and only 1 child table records. This means that:

* Some records of the *table_p* will link to records of *table_ch1*
* Some records of the *table_p* will link to records of *table_ch2*
* Some records of the *table_p* will link to records of *table_ch3*

At first look, this does not make very much sense to me. I thought about
considering 3 parent tables, one for each child table. However, the 3
parent tables would have the same exact structure and I would like to know
if there is a workaround for this issue.

Thanks in advance.

Jorge Maldonado

--000000000000a23af00606c206b1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">Hi,<div><br></div><div>I=
 have one parent table (<b>table_p</b>) with 3 child tables (<b>table_ch1</=
b>, <b>table_ch2 </b>and <b>table_ch3</b>). Each record of the parent table=
 can be associated with 1 and only 1 child table records. This means that:<=
/div><div><br></div><div>* Some records of the <b>table_p</b> will link to =
records of <b>table_ch1</b></div><div>* Some records of the <b>table_p</b> =
will link to records of <b>table_ch2</b><br></div><div>* Some records of th=
e <b>table_p</b> will link to records of <b>table_ch3</b><br></div><div><br=
></div><div>At first look, this does not make very much sense to me. I thou=
ght about considering 3 parent tables, one for each child table. However, t=
he 3 parent tables would have the same exact structure and I would like to =
know if there is a workaround=C2=A0for this issue.</div><div><br></div><div=
>Thanks in advance.</div><div><br></div><div>Jorge Maldonado</div></div></d=
iv></div>

--000000000000a23af00606c206b1--