I've been doing some research about multilingual and recursive database design for few days. I found interesting the following article: http://www.gsdesign.ro/blog/multilanguage-database-design-approach/ and liked the 4th solution Coupled Translation Table Approach. But I'm seriously confused since I don't understand the case; I see there is only one column id on pages table, and I think I need to increase id value firstly on the pages table. After that I must choose id value and add data on the pages_translation table.
The problem is this: how do I know which page corresponds to the value of id? What should I do?
Can you give me some idea about the multilingual and recursive database design approach you're using?
Coupled Translation Table Approach
id (int) name (varchar)
id (int) page_id (int) language_id (int) title (text) content (text)