That's how the database structure when I inherited the software. That's also why I created this 'search cache' thingy. I want to put all things in one table to speed up searching. But it becomes too overloaded with SELECT, INSERT, and UPDATE queries at the same time.

Changing the whole database structure is something I don't want to do right now because we don't have automated test that can give me security in mind.