We also need to store results of these checks only for the projects that have these checks defined, therefore, we'll be creating a new database table named project_compliance_configuration_status for storing results for these requirements.
Proposal
To allow us to go in that state we need the following columns to be added inside the compliance_requirements table.
We would drop the compliance_checks table as we would only use compliance_requirements table.
Column
Type
requirement_type
smallint
expression
jsonb
Also create project_compliance_configuration_status table with the following schema