What would be the correct database structure?

Question

Database design

I need to make a table domain - technologies - technology category

There is such a conclusion:

{'Node.js': {'categories': ['Programming languages']}, 'React': {'categories': ['JavaScript frameworks']}, 'Google Font API': {'categories': ['Font scripts']}, 'Express': {'categories': ['Web frameworks', 'Web servers']}}

It must be made consistent that the site example.com has such technologies. I do not understand how to implement this in the database?
There are 60 categories, more than 1k technologies.

Keeping an array of technology names and using them to get categories is not an option. Because I need the fetch functionality. That is, I want to make queries like: select domain from domains where 'Web servers'='Nginx'

Answer 1

If the mind
connection is many-to-many.
https://habr.com/en/post/193380/
https://habr.com/en/post/488054/
and so on