id | name | address | phoneNumber | website |
---|---|---|---|---|
1 | Sunshine Kindergarten | 123 Main Street | 555-123-4567 | http://www.sunshinelinks.com |
2 | Little Learners | 456 Oak Avenue | 555-987-6543 | http://www.littlelearnersacademy.org |
id | name | address | principalName | mascot |
---|---|---|---|---|
1 | Central High | 123 Main Street | John Doe | Bears |
2 | Eastside Academy | 789 Pine Boulevard | Jane Smith | Panthers |
id | firstName | lastName | subject | schoolID |
---|---|---|---|---|
(→ Schools.id) | ||||
1 | Michael | Smith | Math | 1 |
2 | Emily | Johnson | English | 1 |
3 | David | Williams | History | 2 |
4 | Laura | Martin | Biology | 2 |
id | firstName | lastName | gradeLevel | schoolID |
---|---|---|---|---|
(→ Schools.id) | ||||
1 | Alexander | Doe | 9th | 1 |
2 | Elizabeth | Smith | 10th | 1 |
3 | Samuel | Johnson | 9th | 2 |
4 | Olivia | Williams | 10th | 2 |
id | classTitle | teacherID | startTime | endTime |
---|---|---|---|---|
(→ Teachers.id) | ||||
1 | Algebra I | 1 | 8:00 AM | 9:30 AM |
2 | World History | 3 | 10:00 AM | 11:30 AM |
3 | Physics | 4 | 12:00 PM | 1:30 PM |
id | eventDate | description | location | type |
---|---|---|---|---|
1 | 2023-05-20 | Spring Formal Dance | Gymnasium | Dance |
2 | 2023-06-10 | Graduation Ceremony | Auditorium | Ceremony |