So I've developed 2 modules that depend on each other called decisionpoint and decisionitem.
Decisionitem is basically a label resource, it is related to a single decisionpoint and is hidden from students.
Decisionpoint is an activity that lists the decisionitems so a user can make a choice. When a user makes a choice, the decisionitem and the decisionpoint are marked as complete.
The reason for the development is for access restrictions. So when a user reaches a decisionpoint, they choose a decisionitem. What is displayed next in the course depends on the decision they made.
The problem I have is keeping the relationship between the 2 when backing up. In the decisionitem table I record the decisionpointid which will change when it is restored. Any ideas?