I have done some lessons but not designed a schema before.
I would like some advice for a schema that works with my project in uniity.
I am trying to make a sales tracker for my team at work.
The app has buttons that increases number of kpi’s sold ( I have about 18 to keep track of) and a submit button to send the data to database.
My original idea was to create a large database with one table with userid and all kpis and simply have one line per user and update the total. I would also have a 2nd table that holds username and password ect…
The issue I see is that I wont be able to use dates to collect information and need a new table each month.
Any ideas would be grateful or any advice on websites youtube videos that good for learning.