Add not null contraints to new vulnerability_occurence_id columns
Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.
In Add vulnerability_occurrence_id to to tables th... (#555999 - closed) • Adrien Narinesingh • 18.5 we added vulnerability_occurrence_ids to a set of ref contextual tables to relate them to the branch specific context of their vulnerability.
In Backfill vulnerability_occurrence_id to tables ... (#556203) • Brian Williams • 18.7 we backfilled these columns using the existing vulnerability occurrence that related to the default branch so that they are not orphaned and can be resolved to their appropriate ref context.
Now we need to apply NOT NULL constraints to these table columns to prevent the insertion of invalid data in the future, as well as adding presence validations to the ActiveRecord model for application level validation.