public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: Lookup tables
Date: Tue, 4 Feb 2025 10:12:33 -0500
Message-ID: <CANzqJaCEUN0UnpjW29guR1psfw3JhNmR_AeHEMMmoxCzKJXE_g@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<CANzqJaC3FeJCSy5EUw9VzunBgG3EK6e9=QzUk9wkF8o1Y5iToA@mail.gmail.com>
<[email protected]>
On Tue, Feb 4, 2025 at 10:05 AM Rich Shepard <[email protected]>
wrote:
> On Tue, 4 Feb 2025, Ron Johnson wrote:
>
> > Does your lookup table just have one column? (That's what your question
> > seems to imply, but that makes no sense, since the whole point of a
> lookup
> > table is to store some sort of a code in the "child" table instead of the
> > whole text of the description.)
>
> Ron,
>
> Yes, each has a single column of type names, industrytypes and statustypes.
> I've always used the descriptive names in queries.
>
Yeah, that's definitely Bad Design, for the reason David enumerated.
In the lookup table, the PK can be either synthetic (an integer that means
nothing) or natural (a short text code, typically four characters) that is
an abbreviation of the description.
Synthetic keys have been the norm for the past 25+ years, but I have a soft
spot for natural keys.
Natural keys become unwieldy, though, when more than two columns are
required to define primality.
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
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]
Subject: Re: Lookup tables
In-Reply-To: <CANzqJaCEUN0UnpjW29guR1psfw3JhNmR_AeHEMMmoxCzKJXE_g@mail.gmail.com>
* 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