Code:
entry 10 Text 50 'the word in the language of lang_cd
id 10 Long 4 'the unique id of the word
langCode 10 Long 4 'the code for the specific language
Lang_cd language
1 English
2 French
3 Spanish
with data such as
entry id langCode
cat 1 1
chat 1 2
elgato 1 3
dog 2 1
chien 2 2
elpooper 2 3
horse 3 1
cheval 3 2
caballo 3 3
This makes for a simple dictionary to translate words from one language to another.
I'd probably call it a lookup table also. Lookup a word in a specific language, and get that word in a different language.
eg. What is the Spanish word for the English word "Horse"?
Lookup Horse in English, get the value with the same Id number, and lang_cd for Spanish.
Good luck with your project.