Re: Lookup tables - Mailing list pgsql-general

From Ron Johnson
Subject Re: Lookup tables
Date
Msg-id CANzqJaC3FeJCSy5EUw9VzunBgG3EK6e9=QzUk9wkF8o1Y5iToA@mail.gmail.com
Whole thread Raw
In response to Lookup tables  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Lookup tables
Re: Lookup tables
Re: Lookup tables
List pgsql-general
On Tue, Feb 4, 2025 at 9:28 AM Rich Shepard <rshepard@appl-ecosys.com> wrote:
Should lookup tables have a numeric FK column as well as the description column?

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.)

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Lookup tables
Next
From: "David G. Johnston"
Date:
Subject: Re: Lookup tables