Postgres Pro
Downloads
Home   >   mailing lists

Re: One parent record with 3 possible child records - Mailing list pgsql-sql

From David G. Johnston
Subject Re: One parent record with 3 possible child records
Date
Msg-id CAKFQuwYPeiXTT0GTrN3o7Ja7P9G9Z-LerHsdbzCDqe=SRhffyg@mail.gmail.com
Whole thread Raw
In response to One parent record with 3 possible child records  (JORGE MALDONADO <jorgemal1960@gmail.com>)
Responses Re: One parent record with 3 possible child records
List pgsql-sql
Tree view
On Wednesday, May 1, 2024, JORGE MALDONADO <jorgemal1960@gmail.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.

pgsql-sql by date:

Previous
From: JORGE MALDONADO
Date:
Subject: One parent record with 3 possible child records
Next
From: Sanjay Minni
Date:
Subject: Re: One parent record with 3 possible child records