SIMS icon indicating copy to clipboard operation
SIMS copied to clipboard

Change locations institution code to be required on DB

Open andrewsignori-aot opened this issue 2 years ago • 0 comments

Change column sims.education_programs_offerings.institution_code to be required on DB. As shown below, the field is already required on UI and it must be changed to be required also on the DB.

image.png

Additional context The sims.education_programs_offerings.institution_code has a unique constraint where the code must be unique for an institution which can make it more complex to create default values during the migration. The suggested approach would be to ensure the DEV/TEST DBs have no null entries which would allow the migration to be simplified. A recent effort was done already on TEST DB to ensure that there is no null values on DB and the same should be done on DEV.

Acceptance criteria

  • [ ] Manually check if there are null records on DEV/TEST DB and have then updated (select * from sims.institution_locations where institution_code is NULL)
  • [ ] Create a simple DB migration to change the column to not allow null.

andrewsignori-aot avatar May 02 '23 22:05 andrewsignori-aot