system

테이블 (18)

Action_Log

  • action_id — SERIAL
  • subtask_id — INT
  • student_id — INT
  • action_type — VARCHAR(100)
  • timestamp — TIMESTAMP
  • details — TEXT

Educator

  • educator_id — INT
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • organization — VARCHAR(100)
  • created_at — DATETIME

Help_Request

  • help_id — SERIAL
  • student_id — INT
  • subtask_id — INT
  • issue_description — TEXT
  • requested_at — TIMESTAMP
  • resolved_by — INT
  • resolved_at — TIMESTAMP

Instructor

  • instructor_id — SERIAL
  • name — VARCHAR(100)
  • email — VARCHAR(100)
  • affiliation — VARCHAR(100)

Lecture

  • lecture_id — INT
  • educator_id — INT — NOT NULL
  • lecture_title — VARCHAR(100) — NOT NULL
  • lecture_description — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

LectureStage

  • stage_id — INT
  • lecture_id — INT — NOT NULL
  • stage_order — INT — NOT NULL
  • stage_title — VARCHAR(100) — NOT NULL
  • stage_description — TEXT
  • stage_type — ENUM('교육', '실습', '도움', '완료')
  • expected_duration — INT
  • created_at — DATETIME

Progress

  • progress_id — SERIAL
  • student_id — INT
  • subtask_id — INT
  • status — VARCHAR(50)
  • updated_at — TIMESTAMP

Session

  • session_id — INT
  • lecture_id — INT — NOT NULL
  • educator_id — INT — NOT NULL
  • qr_code — VARCHAR(255)
  • status — ENUM('대기', '진행', '종료')
  • current_stage_id — INT
  • created_at — DATETIME
  • ended_at — DATETIME

SessionStageLog

  • log_id — INT
  • session_id — INT — NOT NULL
  • stage_id — INT — NOT NULL
  • start_time — DATETIME
  • end_time — DATETIME
  • status — ENUM('진행중', '완료', '오류')
  • error_code — VARCHAR(10)
  • assistant_triggered — BOOLEAN
  • feedback_sent — BOOLEAN

Session_Student

  • session_id — INT
  • student_id — INT

Student

  • student_id — SERIAL
  • name — VARCHAR(100)
  • age — INT
  • contact_info — VARCHAR(100)

Subtask

  • subtask_id — SERIAL
  • task_id — INT
  • title — VARCHAR(200)
  • step_order — INT

Task

  • task_id — SERIAL
  • lecture_id — INT
  • title — VARCHAR(200)
  • description — TEXT

교육자 (Untitled)

    세션 (Untitled2)

      세션 참가자 (Untitled5)

        수강자 (Untitled3)

          오류 (Untitled4)