Add id field in project framework settings table
We are adding support for multiple compliance framework labels for a project. Currently only one compliance framework label is allowed per project.
-
project_compliance_framework_settings
table stores mapping of project and compliance framework associated with it. - This table does not have any
id
column and the primary key isproject_id
which means project is a unique field. To support multiple frameworks for a project, we need to addid
column as primary key and remove unique constraint fromproject_id
column as there could be multiple entries for a project. - But we need to make sure that the combination of a project and a framework should be unique, so we need to add a unique constraint on these two fields.
Edited by Hitesh Raghuvanshi