Hello,

I would like to store some frequently asked questions in a database.
As those questions/answers could be translated in several languages, I was thinking of using two tables :

The first table would contain a unique field : the key wich is an id for each faq.

The second table would contain those fields :
FAQ_ID : foreign key
LANG : language
QUESTION : the question translated in the good language.
ANSWER : the answer translated in the good language.

Here are some sample data

What I find embarrassing, is that first table just contains a unique field (the id), just to have a table in which one line correspond to a single object instance. In other words, I just need the first table for object relational mapping...

So I would like to know if it is possible to map several lines of my second table to a single object instance. If it is possible, I don't need the first table.

Thank you in advance.


mathmax