| Data table name | Primary key | Illustrate |
| User table | User ID | Username, password, e-mail, account activation, login time, registration time, teacher, administrator | configuration table | Configuration information number | User ID, name, gender, date of birth, reason for registering | Class schedule | Course No | Course number, course name, name of the school offering the course | Worksheet | Job number | Assignment number, course number, assignment name, assignment evaluation method, assignment | User test form | User ID | Test question number, test question score, user’s score | Assignment submission form | Submit operation number | Course ID, assignment ID, student ID, assignment name, file path |
|
|