public inbox for [email protected]
help / color / mirror / Atom feedFrom: Rob Sargent <[email protected]>
To: David G. Johnston <[email protected]>
Cc: [email protected]
Cc: JORGE MALDONADO <[email protected]>
Subject: Re: One parent record with 3 possible child records
Date: Thu, 2 May 2024 12:28:42 -0600
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKFQuwY6-90W2sO=peE6xf1F07vpbf_4PdKa_bt=4=OAH1GMCw@mail.gmail.com>
References: <CAKFQuwY6-90W2sO=peE6xf1F07vpbf_4PdKa_bt=4=OAH1GMCw@mail.gmail.com>
--Apple-Mail-314D3A98-AE09-452F-B04E-20E8205153A5
Content-Type: text/html;
charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto"><div dir=3D"ltr"></div><div dir=3D"ltr">Got=
cha, thanks</div><div dir=3D"ltr"><br><blockquote type=3D"cite">On May 2, 20=
24, at 8:03=E2=80=AFAM, David G. Johnston <[email protected]>=
wrote:<br><br></blockquote></div><blockquote type=3D"cite"><div dir=3D"ltr"=
>=EF=BB=BF<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" sty=
le=3D"font-family:arial,helvetica,sans-serif"><span style=3D"font-family:Ari=
al,Helvetica,sans-serif">On Thu, May 2, 2024 at 6:37=E2=80=AFAM Rob Sargent &=
lt;<a href=3D"mailto:[email protected]">[email protected]</a>> wr=
ote:</span><br></div></div><div class=3D"gmail_quote"><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,=
204,204);padding-left:1ex"><div style=3D"overflow-wrap: break-word;"><div><b=
lockquote type=3D"cite">Presuming the id is unique in parent and child, what=
=E2=80=99s the value of the type field in the foreign key? Are you say=
ing the PK on tableMain is (type,id), perhaps for clustering purposes?<br></=
blockquote></div><div><br></div></div></blockquote><div><br></div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">Preventi=
ng the parent record from saying "tblOne" while the actual ID value is prese=
nt on "tblTwo".</div><div class=3D"gmail_default" style=3D"font-family:arial=
,helvetica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-=
family:arial,helvetica,sans-serif">David J.</div><div class=3D"gmail_default=
" style=3D"font-family:arial,helvetica,sans-serif"><br></div></div></div>
</div></blockquote></body></html>=
--Apple-Mail-314D3A98-AE09-452F-B04E-20E8205153A5--
view thread (9+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: One parent record with 3 possible child records
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox