Skip to content

Entity: Volunteer

Represents a person who registered interest in volunteering at the institute.

Fields

FieldTypeNullableDefaultDescription
idserialnoautoPrimary key
namevarchar(255)noVolunteer's full name
professionvarchar(255)noVolunteer's profession or area of expertise
availabilityjsonbnoAvailability window: { days: string[], startTime: string, endTime: string }

Standard columns (created_at, updated_at, deleted_at) are inherited per ADR-007 and should not be listed here.

Relations

None.

Business rules

  • availability.days must contain at least one day.
  • availability.days values must be valid English weekday names: monday, tuesday, wednesday, thursday, friday, saturday, sunday.
  • availability.startTime and availability.endTime must be valid times in HH:MM format.
  • availability.endTime must be after availability.startTime.

Notes

  • The volunteer record is persisted for history and future reporting.
  • After registration, the client receives a whatsappUrl to redirect the volunteer to a pre-filled WhatsApp conversation with the institution.