@FeelCore Having reviewed your database structure, language issues aside (some items I was not able to decipher), I think you need to consider the following for a better more robust structure on which to build your application:
Happy to discuss details.
Edit: I made a few small changes and added some comments in the diagram - so above is the replacement
For translation purposes the attached image is from the spreadsheet used to do (some) translation from the Latvian in the OP supplied initial db. It was refined further to produce the above model - so it is not what is being proposed.
Edit: I made a few small changes and added some comments in the diagram - so above is the replacement
For translation purposes the attached image is from the spreadsheet used to do (some) translation from the Latvian in the OP supplied initial db. It was refined further to produce the above model - so it is not what is being proposed.
Last edited: