1. Schema Update: Add role Column to Quality Audit Question Table

• Add a new nullable role column to the questions table.

• • Type: VARCHAR (or ENUM, but string is more flexible for now).

• • Allow NULL to support backward compatibility with existing ECD entries.

• Write a Flyway migration script to apply the schema change safely.

• Ensure it runs successfully in local/dev environments.

2. Data Mapping in DAO and Model Layer

• Update the Entity class to include the new role field mapped to the DB.

• Add a transient roles: List<String> field to accept role data from the client (e.g., via frontend array input).

• Convert roles[] into a single string (comma-separated or pick first) before persisting.

• During retrieval, convert the DB string field back to a transient roles[] structure if needed (for API response).