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