Re: Lookup tables
| От | David G. Johnston |
|---|---|
| Тема | Re: Lookup tables |
| Дата | |
| Msg-id | CAKFQuwYpoUxB8je87ozcajt2L7BrNtN9j9mTfomU6gw=jsKNNg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Lookup tables (Ron Johnson <ronljohnsonjr@gmail.com>) |
| Ответы |
Re: Lookup tables
|
| Список | pgsql-general |
On Tuesday, February 4, 2025, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
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.)
The point of a lookup table is to provide a unique list of authoritative values for some purpose. Kinda like an enum. But having the label serve as the unique value is reasonable - we only add surrogates for optimization.
David J.
В списке pgsql-general по дате отправления: