prototype
Tables (10)
Account (계정)
- id — int — Primary key — NOT NULL
- email (사실상 아이디) — VARCHAR(255)
- password (비밀번호) — VARCHAR(255)
- display_name (계정 이름) — VARCHAR(255)
- is_student (학생여부) — bool
- created_at (생성시기) — datetime
Assignment (과제)
- id — int — Primary key — NOT NULL
- class_id (수업id) — int — Foreign key → Class.id — NOT NULL
- subject_id (과목) — int — Foreign key → Subject.id — NOT NULL
- grade (학년) — VARCHAR(255)
- title (과제명) — VARCHAR(255)
- description (설명) — TEXT
- total_questions (총 문항) — int
- created_at (생성시기) — datetime
- due_at (마감시기) — datetime
Class (수업)
- id — int — Primary key — NOT NULL
- teacher_id (선생님id) — int — Foreign key → Account.id — NOT NULL
- subject_id (과목id) — int — Foreign key → Subject.id — NOT NULL
- name (제목) — VARCHAR(255)
- description (설명) — TEXT
- created_at (생성시기) — datetime
Enrollment (출석부)
- id — int — Primary key — NOT NULL
- student_id (학생id) — int — Foreign key → Account.id — NOT NULL
- class_id (수업id) — int — Foreign key → Class.id — NOT NULL
- status (등록, 초대, 제거) — ENUM
Material (수업자료)
- id — int — Primary key — NOT NULL
- assignment_id (과제id) — int — Foreign key → Assignment.id — NOT NULL
- created_at (생성시기) — datetime
- kind (파일종류) — ENUM
- s3_key (s3키) — TEXT
- bytes — int
- summary (Field) — TEXT
Personal_Assignment (개인별 과제)
- id — int — Primary key — NOT NULL
- student_id (학생id) — int — Foreign key → Account.id — NOT NULL
- assignment_id (과제id) — int — Foreign key → Assignment.id — NOT NULL
- status (진행상황) — ENUM
- solved_num (푼 문제수) — int
- started_at (시작일) — datetime
- submitted_at (제출일) — datetime
Subject (과목)
- id — int — Primary key — NOT NULL
- name (과목명) — VARCHAR(255)
- created_at (생성시기) — datetime
answer (대답)
- id (Key) — int — Primary key — NOT NULL
- question_id — int — Foreign key → question.id — NOT NULL
- student_id (학생id) — int — Foreign key → Account.id — NOT NULL
- started_at (답변시작시기) — datetime
- submitted_at (답변제출시기) — datetime
- state (정답/오답) — ENUM
- text_answer (학생제출답변) — TEXT
- eval_grade (평가 등급) — float
- created_at (생성시기) — datetime
question (질문)
- id — int — Primary key — NOT NULL
- prev_question_id (이전질문id) — int — Foreign key → question.id — NOT NULL
- personal_assign_id (개인과제id) — int — Foreign key → Personal_Assignment.id — NOT NULL
- number (문항번호) — int
- recalled_num (몇 번째 꼬리 문제인지) — int
- content (내용) — VARCHAR(255)
- topic (단원) — VARCHAR(255)
- explanation (해설) — TEXT
- model_answer (모범답안) — TEXT
- created_at (생성시기) — datetime
- difficulty (난이도) — enum
- achievement_code (성취기준 코드) — VARCHAR(32)
teacher_feedback (첨언)
- id — int — Primary key — NOT NULL
- class_id (수업id) — int — Foreign key → Class.id — NOT NULL
- teacher_id (선생님id) — int — Foreign key → Account.id — NOT NULL
- student_id (학생id) — int — Foreign key → Account.id — NOT NULL
- content (내용) — TEXT
- created_at (생성시기) — datetime