id | name | population |
---|---|---|
1 | New York | 8398748 |
2 | Los Angeles | 3960215 |
3 | Chicago | 2697391 |
4 | Houston | 2326146 |
5 | Phoenix | 1681115 |
id | full_name |
---|---|
1 | New York |
2 | California |
3 | Illinois |
4 | Texas |
5 | Arizona |
id | campus_name | city_id | state_id |
---|---|---|---|
(→ City.id) | (→ State.id) | ||
1 | New York University | 1 | 1 |
2 | University of California Los Angeles | 2 | 2 |
3 | University of Chicago | 3 | 3 |
4 | University of Houston | 4 | 4 |
5 | Arizona State University | 5 | 5 |
id | firstName | lastName | |
---|---|---|---|
1 | John | Doe | john.doe@example.com |
2 | Jane | Smith | jane.smith@example.com |
3 | Michael | Brown | michael.brown@example.com |
4 | Alice | Johnson | alice.johnson@example.com |
5 | David | Wilson | david.wilson@example.com |
teacherId | campusId | startDate | endDate |
---|---|---|---|
(→ Teacher.id) | (→ Campus.id) | ||
1 | 1 | 2021-01-01 | 2021-12-31 |
2 | 2 | 2021-01-01 | 2021-12-31 |
3 | 3 | 2021-01-01 | 2021-12-31 |
4 | 4 | 2021-01-01 | 2021-12-31 |
5 | 5 | 2021-01-01 | 2021-12-31 |
id | firstName | lastName | |
---|---|---|---|
1 | Emily | Davis | emily.davis@example.com |
2 | Alexander | Martinez | alexander.martinez@example.com |
3 | Olivia | Garcia | olivia.garcia@example.com |
4 | William | Anderson | william.anderson@example.com |
5 | Isabelle | Jackson | isabelle.jackson@example.com |
studentId | campusId | enrollmentStartDate |
---|---|---|
(→ Student.id) | (→ Campus.id) | |
1 | 1 | 2021-01-01 |
2 | 2 | 2021-01-01 |
3 | 3 | 2021-01-01 |
4 | 4 | 2021-01-01 |
5 | 5 | 2021-01-01 |