Scholar
The scholar model represents individual students enrolled in institutions who receive financial support through campaigns. Scholars can be associated with multiple campaigns and have family background information attached. Below, we outline the different properties associated with a scholar.
Properties
- Name
id- Type
- integer
- Description
Unique identifier for the scholar
- Name
institution_id- Type
- integer
- Description
Foreign key to the institution where the scholar is enrolled
- Name
first_name- Type
- string
- Description
Scholar's first name
- Name
middle_name- Type
- string | null
- Description
Scholar's middle name
- Name
last_name- Type
- string
- Description
Scholar's last name
- Name
nickname- Type
- string | null
- Description
Scholar's preferred nickname
- Name
birthdate- Type
- date | null
- Description
Scholar's birth date
- Name
story- Type
- text | null
- Description
Scholar's personal story or background
- Name
contact_number- Type
- string | null
- Description
Contact phone number
- Name
gender- Type
- enum | null
- Description
Gender:
male,female,other
- Name
email- Type
- string | null
- Description
Scholar's email address
- Name
address- Type
- text | null
- Description
Current residential address
- Name
photo- Type
- string | null
- Description
URL to scholar's photo
- Name
created_at- Type
- timestamp
- Description
Record creation timestamp
- Name
updated_at- Type
- timestamp
- Description
Record last update timestamp
Relationships
- Name
institution- Type
- Institution
- Description
The institution where the scholar is enrolled. See Institutions
- Name
campaigns- Type
- Campaign[]
- Description
Campaigns supporting this scholar. See Campaigns
- Name
familyBackgrounds- Type
- FamilyBackground[]
- Description
Family members' information. See below
Family Background
- Name
id- Type
- integer
- Description
Unique identifier for the family member record
- Name
scholar_id- Type
- integer
- Description
Foreign key to the scholar
- Name
first_name- Type
- string
- Description
Family member's first name
- Name
last_name- Type
- string
- Description
Family member's last name
- Name
relationship- Type
- enum
- Description
Relationship:
father,mother,sibling,guardian,spouse,other
- Name
occupation- Type
- string | null
- Description
Current occupation
- Name
monthly_income- Type
- decimal | null
- Description
Monthly income in PHP
- Name
status- Type
- enum
- Description
Employment status:
employed,unemployed,self-employed,retired,student