How to design a competently SQL database?

Question

SQL

Friends, I understand that we need to study the topic seriously. Going to. But curiosity gnaws.
I plan to write for myself and others a site-task scheduler in php / sql.
Suppose each user can have a total of 1000 or more cases (with priority, date, etc.).
And for example, there will be more than 1000 such users.
How is the base designed? One table for affairs of all users is created? Or will each user have their own table with cases? Or somehow else?
Thank you!
Please do not post off topic. Why do you want it? Why are ready-made ones not satisfied? The questioner is a noob! Etc. Just pass by.
PS: what would you recommend to read on the competent design of large databases?
To all who responded - many thanks and respect!

Answer 1

One table for all cases, all users, 1 million records funny numbers =)