good database design for localization

Posted by rap-uvic on Stack Overflow See other posts from Stack Overflow or by rap-uvic
Published on 2010-03-21T02:29:31Z Indexed on 2010/03/21 2:31 UTC
Read the original article Hit count: 450

Hi,

I have 3 tables for localization: Locales, ResourceKeys, and Resources. Resources is a many to many table between ResourceKeys and Locales, and stores Resource values for each resource key in multiple languages.

Now if I have a table called Event, which needs a localized title and description, how do I best do this? Do I create foreign key columns in Event table which point to ResourceKey IDs each for title and description, or is there a better way?

© Stack Overflow or respective owner

Related posts about localization

Related posts about database-design