Context
PR #482 adds three new date-based columns to track when document statuses were set:
statusVaccinationDate
statusCGCApplicationDate
statusCGCDate
The old enum-based columns are now redundant and should be removed once all code is adapted.
Old columns to remove
| Column |
Type |
Replaced by |
statusVaccination |
DocumentStatusType |
statusVaccinationDate (set = YES, null = NO) |
statusCGC |
DocumentStatusType |
statusCGCDate / statusCGCApplicationDate |
statusCgcProcess |
VolunteerStateCGCType |
statusCGCApplicationDate |
Files to update (BE)
src/data/entity/volunteer/volunteer.entity.ts — remove 3 @Column declarations
src/server/utils/data/get-volunteer-patch-data.ts — remove statusCGC, statusVaccination, statusCgcProcess from patch object
src/services/dto/dto-volunteer.ts — remove goodConductCertificate, measlesVaccination, statusCgcProcess from serializer
src/services/dto/parser-volunteer-form.ts — remove statusVaccination/statusCGC mappings
src/data/seeds/types.ts + volunteer.seed.ts — remove from seed types
- New migration —
DROP COLUMN for all 3
Files to update (FE)
Dependency
Must be done after PR #482 is merged and deployed.
Context
PR #482 adds three new date-based columns to track when document statuses were set:
statusVaccinationDatestatusCGCApplicationDatestatusCGCDateThe old enum-based columns are now redundant and should be removed once all code is adapted.
Old columns to remove
statusVaccinationDocumentStatusTypestatusVaccinationDate(set = YES, null = NO)statusCGCDocumentStatusTypestatusCGCDate/statusCGCApplicationDatestatusCgcProcessVolunteerStateCGCTypestatusCGCApplicationDateFiles to update (BE)
src/data/entity/volunteer/volunteer.entity.ts— remove 3@Columndeclarationssrc/server/utils/data/get-volunteer-patch-data.ts— removestatusCGC,statusVaccination,statusCgcProcessfrom patch objectsrc/services/dto/dto-volunteer.ts— removegoodConductCertificate,measlesVaccination,statusCgcProcessfrom serializersrc/services/dto/parser-volunteer-form.ts— removestatusVaccination/statusCGCmappingssrc/data/seeds/types.ts+volunteer.seed.ts— remove from seed typesDROP COLUMNfor all 3Files to update (FE)
src/components/Dashboard/Profile/sections/VolunteerProfileDocument/utils.ts—measlesVaccinationname keyDependency
Must be done after PR #482 is merged and deployed.