Data Type Qualifiers Definition PostgreSQL

Question

How would I go about defining a table with a language specific (qualified) attribute?

For example:

ID| object |description (english)|description (french)| size | color (english) | color (french)

in the above example we have 3 'normal' fields and 2 language qualified fields : description and color.

What is best practice for defining these type of fields within one table?

Gordon Linoff · Accepted Answer · 2017-05-14 19:59:36Z

1

There are different ways of doing this. But a method for your specific data is to have another table with one row per language. Such as table would have:

objectLanguageId (serial column to identify the row)
objectId (reference to a table with one row per object)
language
description
color

Then the "object" table would have

objectId
objectName
size

Note: This is definitely not the only approach. If you need everything in your system translated, then you want a more sophisticated and generic mechanism. You may also need to take into account things like French sizes are different from sizes in other countries -- even countries that speak the same language.

answered May 14, 2017 at 19:59

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Melkier Jordán Over a year ago

This makes perfect sense. Thank you

Collectives™ on Stack Overflow

Data Type Qualifiers Definition PostgreSQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related