Resolve "Preventing accidental project deletion" -db changes

What does this MR do?

This MR introduces soft-delete feature for projects - fields in db we need to make it work.

Screenshots

Does this MR meet the acceptance criteria?

Conformity

• Changelog entry
• Documentation created/updated or follow-up review issue created
• Code review guidelines
• Merge request performance guidelines
• Style guides
• Database guides
• Separation of EE specific content

Performance and Testing

• Review and add/update tests for this feature/bug. Consider all test levels. See the Test Planning Process.
• Tested in all supported browsers

Related to #32935 (closed)