Student fields

Personal information

Field	Type	Required	Description
first_name	Text	Yes	Student's first name
last_name	Text	Yes	Student's last name
date_of_birth	Date	Yes	Format: YYYY-MM-DD
gender	Enum	Yes	male, female
nationality	Text	No	Country of citizenship
blood_group	Text	No	Blood type (A+, B-, etc.)
address	Text	No	Home address
photo_url	URL	No	Student profile photo

Academic information

Field	Type	Required	Description
student_id	Text	Auto	Auto-generated unique identifier
class_id	Reference	Yes	Assigned class
enrollment_date	Date	Auto	Date of enrollment
status	Enum	Auto	active, inactive, graduated

Guardian fields

Field	Type	Required
guardian_name	Text	Yes
guardian_relationship	Enum	Yes (Father, Mother, Guardian, Other)
guardian_phone	Text	Yes
guardian_email	Email	No
guardian_occupation	Text	No

Medical fields

Field	Type	Required
allergies	Text	No
medical_conditions	Text	No
medications	Text	No
emergency_contact	Text	No