Re: One parent record with 3 possible child records

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: One parent record with 3 possible child records
Date: 2024-05-01 23:24:15
Message-ID: CAKFQuwYPeiXTT0GTrN3o7Ja7P9G9Z-LerHsdbzCDqe=SRhffyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wednesday, May 1, 2024, JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> wrote:

>
> Let's say that tableMain has a string field called "type" with the
> following possible values: "residential", "industrial" and "energy".
>

This, and have the same column in the other tables, but add a check
constraint ensuring only the correct enum value can be specified. Then
your foreign key from the child tables to main is both the ID and the type
field.

David J.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Sanjay Minni 2024-05-02 13:33:44 Re: One parent record with 3 possible child records
Previous Message JORGE MALDONADO 2024-05-01 23:08:33 One parent record with 3 possible child records