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