How to implement a project progress tracker?

Question

Database design

The essence of the task is as follows: it is necessary to implement tracking of the implementation of project stages. I thought of making a Project model and a Stage model, then link them sequentially one2one, but then I would have to write a separate method to add a new stage in the middle of the chain - would this be a good solution?
I also thought of simply assigning serial numbers to the stages, but then again, if you change in the middle, you will have to rewrite everything below.
Has anyone encountered something similar, maybe there are some more cunning and simple solutions?

Answer 1

O2O communication means that a Project can have only one Stage, and a Stage can have only one Project. O2O relationships are most often meaningless and are created to optimize the database and separate entities into different tables.
There is a very simple solution - to read books about databases and building their architecture, to get better acquainted with the types of relationships.