how to localize a table with multiple text entries?
- by rap-uvic
Hello,
I'm writing a web app which will allow creation of events.  An event can have a title as well as a description amongst other things.  The app needs to be multilingual.  So I have 4 tables for localization: ResourceTypes, ResourceKeys, Resources, and Locales.  A resource key can have multiple values in Resources table for different locales.  So Resources is a many to many table between ResourceKeys and Locales.
So in the event table I want to have a resourceKey for its title as well as a resourceKey for its description.  So my question is, is it OK from database-design perspective to have two foreign keys from a table into another table?
Has anybody used a better approach in such a scenario?