One Column Per Language

In this structure, tables contain sets of 23 columns, one for each language.

A logical naming convention is used to indicate which language a column contains. The name of each column ends with a language code suffix, such as _EN for English and _FR for French. For example, the column that contains information about countries and regions is named COUNTRY_FR for French data and COUNTRY_DE for German data. All tables use this structure except for PRODUCT_LOOKUP