I read this https://processwire.com/talk/topic/3579-tutorial-approaches-to-categorising-site-content/
Now I'm designing a German to English and vice versa table but categorized by theme. I end up doing a flat table in PW. That is one page with following fields,
CategoryName (e.g. greetings, house, school, etc.),(text field).
GermanWord (repeater field)
EnglishWord(repeater field)
That way I can search by category (i.e.find the with that category) and the user will see German/English words is that category. Example school category might show the following words, teacher, pupil, library, etc. Is it correct to say that the page design above is equivalent to row in a classic SQL join table where in the template used by that page is the join table itself?