Design question what pattern to use
- by rahul
Problem Description:
We have a requirement of storing the snapshot of an entity temporarily in the database untill a certain period of time untill all the processes to approve the data are completed. Once all approvals are completed the data shall be permanantly persisted into the actual table.
Example:
1) Consider an entity called "User". One way to create the user is through the "Create Account Process".
2) The "Create Account Process" shall capture all the information of the User and store it in a temporary table in the database.
3) The data shall be used by the "Account Approval Process" to run its verification process.
4. After all the verification is completed successfully, the User data shall be persisted to the actual table.
Question:
Where to store the user data entered during "Create Account Process". Additionally, User data should be editable till the verification process is complete.