Language assets information model diagram description

The following diagram depicts the language asset information model.

Alternative language

When information is not available in the one of the supported languages the store tries to display the information in an alternative language, if it is available. An alternative language is always part of one store, or store entity, meaning that a store can have zero or more alternative languages.

Supported language

The STORELANG table indicates the languages each store supports. A store must be able to display information in its supported languages, or one of their alternative languages. A supported language is always part of one store, or store entity, meaning that a store can have zero or more supported languages.

Default language

A default language is associated with each store. This is the language that the store has chosen to use as its main language, and will be the language displayed to customers that do not explicitly choose a shopping language. A default language is specific to a store and thus, the default language is shown as dependant on the Store.

Shopping language

The shopping language is the language that is used when displaying pages to a particular customer. If the customer's preferred language is supported by the store or site, then the preferred language is used as the shopping language. Otherwise, the shopping language is the default language for the store or site. There can only be one shopping language per customer and thus, the shopping language is shown as dependant on the language that the store supports.