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