| id | photograph | subject | description | difficulty_level | date |
|---|---|---|---|---|---|
| 1 | Sunset | Nature | A beautiful sunset over a lake. | Beginner | 2024-03-13 18:14:00 |
| 2 | Cityscape | Architecture | A panoramic view of a bustling city. | Intermediate | 2024-03-13 18:14:00 |
| id | illustration | subject | description | difficulty_level | date |
|---|---|---|---|---|---|
| 1 | Forest Scene | Nature | An intricate drawing of a dense forest. | Advanced | 2024-03-13 18:14:00 |
| 2 | Urban Landscape | Architecture | An artistic depiction of an urban landscape. | Expert | 2024-03-13 18:14:00 |
| id | name | specialization | experience | contact | hire_date |
|---|---|---|---|---|---|
| 1 | John Doe | Art History | 10 | johndoe@example.com | 2024-03-13 18:14:00 |
| 2 | Jane Smith | Literature | 8 | janesmith@example.com | 2024-03-13 18:14:00 |
| id | firstname | lastname | grade | enrollment_date |
|---|---|---|---|---|
| 1 | Alice | Smith | 12th Grade | 2024-03-13 18:14:00 |
| 2 | Bob | Johnson | 9th Grade | 2024-03-13 18:14:00 |
| class_id | teacher_id | student_id | start_time | end_time |
|---|---|---|---|---|
| (→ Teachers.id) | (→ Students.id) | |||
| 1 | 1 | 1 | 09:00:00 | 10:30:00 |
| 2 | 2 | 2 | 10:00:00 | 11:30:00 |
| subject_id | subject_name | description |
|---|---|---|
| 1 | Mathematics | The study of numbers, quantities, shapes, and patterns. |
| 2 | History | The study of past events and their causes, effects, and significance. |