The best practice for SQL + NoSQL database design
From comments:

This question is incredibly open-ended and has an entire branch of the industry devoted to it, namely data-architects and program-architects. The best thing to do is to pick ONE concept and stick with it. Thousands of users is a low-threshold for performance, so any solution will work. Are you expected to present a design or an implementation? Any database system can implement almost any sort of ERD, so just focus on a solid ERD.
There are plenty of options on what should happen here, and there are professional patterns that you may miss in your design (knowing how to build appropriate M:N relations based on experience) or things like audit tables that you may not be considering (we do a lot of this sort of thing post-academia, and know a lot of questions to ask stakeholders to ensure we build the right things). Just do the best work you can, and work with your advisor to know if it's enough for your diploma project. - jcolebrand

And one other suggestion from another comment:

You might like to try using PostgreSQL which has both classic RDBMS and a Document Store capability within the same database - indeed, you can join between classic tables and JSONB documents. Just a thought! – Vérace