Add NOT NULL for sharding key on dast_site_validations

What does this MR do and why?

Add NOT NULL constraint to dast_site_validations.project_id column.

We do not add a validation on the model because we're populating the column using a "BEFORE INSERT OR UPDATE" trigger.

References

• Related to #493768 (closed)

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Screenshots or screen recordings

N/A

How to set up and validate locally

N/A