classday_learning_server
Tables (5)
textbook_assignment
- id — BIGINT — Primary key — NOT NULL
- edu_space_id — BIGINT — NOT NULL
- textbook_id — BIGINT — NOT NULL
- assigned_by_user_id — BIGINT — NOT NULL
- textbook_info — JSON — NOT NULL
- status — ENUM('IN_PROGRESS', 'COMPLETED') — NOT NULL
- create_time — DATETIME(3) — NOT NULL
- update_time — DATETIME(3) — NOT NULL
textbook_assignment_target
- id — BIGINT — Primary key — NOT NULL
- textbook_assignment_id — BIGINT — Foreign key → textbook_assignment.id — NOT NULL
- edu_space_id — BIGINT — NOT NULL
- edu_class_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- create_time — DATETIME(3) — NOT NULL
textbook_grading_result
- id — BIGINT — Primary key — NOT NULL
- edu_space_id — BIGINT — NOT NULL
- textbook_id — BIGINT — NOT NULL
- textbook_page_id — BIGINT — NOT NULL
- textbook_problem_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- textbook_homework_id — BIGINT — Foreign key → textbook_homework.id
- graded_by_user_id — BIGINT — NOT NULL
- is_correct — TINYINT(1)
- create_time — DATETIME(3) — NOT NULL
- update_time — DATETIME(3) — NOT NULL
textbook_homework
- id — BIGINT — Primary key — NOT NULL
- edu_space_id — BIGINT — NOT NULL
- edu_class_id — BIGINT
- textbook_assignment_id — BIGINT — Foreign key → textbook_assignment.id — NOT NULL
- textbook_id — BIGINT — NOT NULL
- assigned_by_user_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- due_date — DATETIME
- pages — JSON — NOT NULL
- message_id — BIGINT
- create_time — DATETIME(3) — NOT NULL
- update_time — DATETIME(3) — NOT NULL
textbook_homework_target
- id — BIGINT — Primary key — NOT NULL
- textbook_homework_id — BIGINT — Foreign key → textbook_homework.id — NOT NULL
- target_type — ENUM('CLASS', 'STUDENT') — NOT NULL
- edu_class_id — BIGINT
- user_id — BIGINT
- create_time — DATETIME(3) — NOT NULL