I need to be able to store string messages in various languages. I guess I need a column for each language string. For example my columns could be:
ID | message_EN | message_DE | message_FR
Now, I have strings in various tables in the DB. Should I use one large string table with the above structure (or similar) where most other tables will be joined (via string ID), or have multiple tables with the same structure each related to one table? Most probably there will not be much overlap between the data of multiple tables. Are there any performance considerations with using one large table?