Add a Reviewer foreign key to the scenario to show who is reviewing it
Add a Submitter foreign key for the user that submitted the scenario
Add a Published/Public/reviewed Boolean that would show the scenario is approved and is publicly searchable.
Possible Parent ID of the original Scenario if we go with option 2.a for editing scenarios. this is where the original scenario is kept for auditing but a new scenario is created for each edit.
Add a Reviewer foreign key to the scenario to show who is reviewing it
Add a Submitter foreign key for the user that submitted the scenario
Add a Published/Public/reviewed Boolean that would show the scenario is approved and is publicly searchable.
Possible Parent ID of the original Scenario if we go with option 2.a for editing scenarios. this is where the original scenario is kept for auditing but a new scenario is created for each edit.