Sorry for the late response... holidays 🙂

Yes i know that i need to redesign the table, that's why i ask for help 🙂

My business logic isn't like the normal product logic, every product it's different from the others, so it has to have it own reg.

Like i wrote, i have 4 transitions and 6 states for each one, the product it's created (process/docs), the process it's delivered to the 2D design, sent to approval, sent to 3D, sent to production and finally the product it's finished.

I need to save all the dates and the users that do something in all the process...

I do understand that i need to somehow break this big table, into small ones, but that's my problem i don't know what's the best way to do that, and do that in some kind of way that left some room to change the number of states that the products can have in the future (my boss may want to add for example, another approval between the 3D and the production or remove the existing one between the 2D and the 3D department).

Thanks