Students Table
Field Name | Description | Data Type | Example Value |
---|---|---|---|
Student Number | The unique identifier for the student in the system. | Integer | 100001 |
Last Name | The student's last name. | String | Smith |
First Name | The student's first name. | String | John |
Grade Level | The student's current grade level. | Integer | 11 |
Homeroom Teacher | The name of the teacher assigned to the student's homeroom class. | String | Ms. Johnson |
Enrollment Date | The date the student was enrolled in the school. | Date | 2022-09-01 |
Gender | The student's gender. | String | Male |
Birthdate | The student's date of birth. | Date | 2005-06-15 |
Guardians Table
Field Name | Data Type | Description |
---|---|---|
First Name | Text | First name of the guardian |
Last Name | Text | Last name of the guardian |
Relationship | Text | Relationship of the guardian to the student |
Text | Email address of the guardian | |
Home Phone | Text | Home phone number of the guardian |
Work Phone | Text | Work phone number of the guardian |
Cell Phone | Text | Cell phone number of the guardian |
Address | Text | Mailing address of the guardian |
City | Text | City of the guardian's mailing address |
State | Text | State of the guardian's mailing address |
Zip Code | Text | Zip code of the guardian's mailing address |
Primary | Boolean | Indicates if the guardian is the primary contact for the student |
Authorization | Boolean | Indicates if the guardian has authorization to pick up the student from school |