I'm trying to design a capacity planning tables. Idea is to have a possibility to plan each unique item (1000 new unique items per year) to date that I choose. What would be the best solution to design a database on that? Solution that I come up is to create 2 tables 1) unique item ID with all dates 2) Items with required quantity (Please see image). Problem is that using this solution I would have ~10 million of records in dates table within 5 years which seems a lot. Is there some other way to design it?
I'm not able to answer your question as I don't understand the info you posted. But I wanted to mention that 10 million rows in a table is not at all a big table, especially if it's over 5 years. Some of us support systems that receive that many or MORE inserts PER DAY.
I want to create a simple php + mysql production planning tool. Meaning that producing each item requires certain amount of time and number of working hours per day limits how much I could plan to produce each day.