I'm working on a job platform and i'm struggling with multilanguage functionality.
We have two sides - the candidate and the company who is searching for fitting candidates:
Candidate site:
The candidate fills out the form (either in german or english). He also fills out his work experience -> E.g. Software Developer for 3 years.
Company site:
The company site has a backend where they can search/filter the candidates. The problem here is, that the companies are german only - meaning:
If they search for "Softwareentwickler" (german for Software Developer) they should find both -> "Softwareentwickler" and Software Developer
My approach to do that:
I have a table with predefined working categories (candidates can add to it)
id label lang_key ....
1 Software Developer de
1 Software Entwickler en
And the categories are then associated to the candidates like that:
candidate_id category_id
1 1
So then the company can filter for both -> Software Entwickler and Software Developer.
Since this is a bigger task to do i would like to know, if this approach makes sense - since this would would mean manual translating of categories.
I'm using Java Spring, Angular + Angular material Frontend, MySql Database and probably later ElasticSearch.