Databases

Multi-Language Content Localization Schema

ER Diagrams · made in Skemio

ER diagram illustrating locales, articles, and article translations tables with composite primary keys for internationalization.
ER diagram illustrating locales, articles, and article translations tables with composite primary keys for internationalization.
Open it in SkemioMake your own

What it shows

  • Decouple locale-agnostic entities from localized text translations.
  • Composite keys on (entity_id, locale_code) eliminate duplicate translations.
  • Fall back gracefully to default locales when specific translations are missing.

The takeaway

Never add language columns horizontally; isolate localized attributes into a dedicated translation table.

More er diagrams