Appearance
Entity: Volunteer
Represents a person who registered interest in volunteering at the institute.
Fields
| Field | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | serial | no | auto | Primary key |
| name | varchar(255) | no | — | Volunteer's full name |
| profession | varchar(255) | no | — | Volunteer's profession or area of expertise |
| availability | jsonb | no | — | Availability 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.daysmust contain at least one day.availability.daysvalues must be valid English weekday names:monday,tuesday,wednesday,thursday,friday,saturday,sunday.availability.startTimeandavailability.endTimemust be valid times inHH:MMformat.availability.endTimemust be afteravailability.startTime.
Notes
- The volunteer record is persisted for history and future reporting.
- After registration, the client receives a
whatsappUrlto redirect the volunteer to a pre-filled WhatsApp conversation with the institution.