Improve precision of DB jsonSchema property constraints

[jujaga]

Description

This PR focuses on improving the DB jsonSchema constraints so that only proper/accurate information can enter the database. While our previous restrictions were sufficient for most effective situations, raising the specificity allows us to reduce the possibility of having improper data slip into our database. This PR also applies routine security maintenance and dependency updates.

SHOWCASE-3590

Types of changes

New feature (non-breaking change which adds functionality)

Checklist

• [x] I have read the CONTRIBUTING doc
• [x] I have checked that unit tests pass locally with my changes
• [x] I have added tests that prove my fix is effective or that my feature works
• [x] I have added necessary documentation (if appropriate)

Further comments

[codeclimate[bot]]

Code Climate has analyzed commit 47f55f33 and detected 8 issues on this pull request.

Here's the issue category breakdown:

Category	Count
Duplication	8

The test coverage on the diff in this pull request is 100.0% (50% is the threshold).

This pull request will bring the total coverage in the repository to 68.2% (0.0% change).

View more on Code Climate.

[github-actions[bot]]

Coverage Report

Totals
Statements:	61.22% ( 3048 / 4979 )
Methods:	51.15% ( 335 / 655 )
Lines:	68.28% ( 1834 / 2686 )
Branches:	53.66% ( 879 / 1638 )