test

Tables (22)

auth_refresh_sessions

  • id — bigint — Primary key — NOT NULL
  • teacher_id — bigint — Foreign key → teachers.id — NOT NULL
  • student_id — bigint
  • audience — varchar(30) — NOT NULL — ADMIN or LEARNING
  • token_hash — char(64) — NOT NULL
  • expires_at — timestamp — NOT NULL
  • revoked_at — timestamp
  • created_at — timestamp — NOT NULL

character

  • id — bigint — Primary key — NOT NULL
  • student_id — bigint — Foreign key → students.id — NOT NULL
  • story_id — bigint — NOT NULL
  • image_url — varchar(255)
  • created_at — timestamp — NOT NULL
  • name — varchar(50)

curriculum_units

  • id — bigint — Primary key — NOT NULL
  • unit_name — varchar(50) — NOT NULL — 파닉스, 단어 etc
  • sequence_no — int

daily_curriculums

  • id — bigint — Primary key — NOT NULL
  • student_id — bigint — Foreign key → students.id — NOT NULL
  • status — varchar(20) — NOT NULL — Enum: NOT_STARTED, IN_PROGRESS, COMPLETED
  • created_at — timestamp — NOT NULL
  • completed_at — timestamp

gaze_analysis_results

  • id — bigint — Primary key — NOT NULL
  • gaze_session_id — bigint — Foreign key → gaze_sessions.id — NOT NULL
  • total_visited_duration — int — NOT NULL
  • total_visited_count — int — NOT NULL
  • reverse_read_count — int — NOT NULL
  • avg_visited_duration — int
  • created_at — timestamp — NOT NULL

gaze_sessions

  • id — bigint — Primary key — NOT NULL
  • student_id — bigint — Foreign key → students.id — NOT NULL
  • test_id — bigint
  • training_id — bigint
  • story_id — bigint
  • content_type — varchar(20) — NOT NULL — TEST, TRAINING, STORY
  • started_at — timestamp — NOT NULL
  • ended_at — timestamp
  • status — varchar(20) — NOT NULL — READY, RUNNING, COMPLETED, FAILED
  • calibration_status — varchar(20) — NOT NULL — NOT_STARTED, SUCCESS, FAILED, SKIPPED
  • created_at — timestamp — NOT NULL

reports

  • id — bigint — Primary key — NOT NULL
  • student_id — bigint — Foreign key → students.id — NOT NULL
  • start_date — timestamp — NOT NULL — 기간시작일~기간종료일 에 대한 리포트
  • end_date — timestamp — NOT NULL
  • snapshot_data — json
  • teacher_memo — text
  • created_at — timestamp — NOT NULL — 생성일

stories

  • id — bigint — Primary key — NOT NULL
  • student_id — bigint — Foreign key → students.id — NOT NULL
  • story_template_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • status — varchar(30) — NOT NULL — Enum: IN_PROGRESS/COMPLETED/DELETED
  • progress — tinyint — NOT NULL — 이야기 진행률(0~100)

story_choices

  • id — bigint — Primary key — NOT NULL
  • story_line_id — bigint — Foreign key → story_lines.id — NOT NULL
  • content — text — NOT NULL
  • created_at — timestamp — NOT NULL

story_lines

  • id — bigint — Primary key — NOT NULL
  • scene_id — bigint — Foreign key → story_scenes.scene_id — NOT NULL
  • has_choices — boolean — NOT NULL
  • content — text — NOT NULL
  • sequence_no — int — NOT NULL
  • created_at — timestamp — NOT NULL
  • read_at — timestamp

story_scenes

  • scene_id — bigint — Primary key — NOT NULL
  • story_id — bigint — Foreign key → stories.id — NOT NULL
  • image_url — varchar(255)
  • sequence_no — int — NOT NULL
  • created_at — timestamp — NOT NULL

story_templates

  • id — bigint — Primary key — NOT NULL
  • title — varchar(50) — NOT NULL
  • content — text — NOT NULL — ai에게 컨텍스트주는용도(ex: 백설공주의 줄거리)
  • image_url — varchar(255)

students

  • id — bigint — Primary key — NOT NULL
  • teacher_id — bigint — Foreign key → teachers.id — NOT NULL — foreign key
  • name — varchar(10) — NOT NULL — 실명
  • birthday — date
  • gender — varchar(10) — Enum: boy, girl
  • school — varchar(20)
  • guardian — varchar(10)
  • guardian_contact — varchar(20)
  • guardian_email — varchar(50)
  • address — varchar(100)
  • created_at — timestamp — NOT NULL — 생성일
  • image_url — varchar(255)
  • teacher_memo — text

teachers

  • id — bigint — Primary key — NOT NULL
  • email — varchar(50) — NOT NULL — unique
  • password — varchar(100) — NOT NULL
  • name — varchar(10) — NOT NULL — 실명
  • organization — varchar(100)
  • created_at — timestamp — NOT NULL — 생성일
  • gender — varchar(10) — Enum
  • image_url — varchar(255)

test_datas

  • id — varchar(255) — Primary key — NOT NULL
  • test_id — bigint — Foreign key → tests.id — NOT NULL
  • question — json — 문항문제

tests

  • id — bigint — Primary key — NOT NULL
  • student_id — bigint — Foreign key → students.id — NOT NULL
  • created_at — timestamp — NOT NULL
  • status — varchar(20) — Enum: NOT_READY, NOT_STARTED, IN_PROGRESS, COMPLETED
  • result — json — 문항별 정답유무/틀린부분
  • accuracy — decimal — 정답률

training_datas

  • id — bigint — Primary key — NOT NULL
  • train_id — bigint — Foreign key → trainings.id — NOT NULL
  • generated_data — json — 훈련에서 쓰일 단어/문장(ai생성)
  • created_at — timestamp

training_templates

  • id — bigint — Primary key — NOT NULL
  • curriculum_unit_id — bigint — Foreign key → curriculum_units.id — NOT NULL
  • name — varchar(100) — NOT NULL
  • form — json — NOT NULL
  • sequence_no — int — NOT NULL

trainings

  • id — bigint — Primary key — NOT NULL
  • training_template_id — bigint — Foreign key → training_templates.id — NOT NULL
  • daily_curriculum_id — bigint — NOT NULL
  • sequence_no — int — NOT NULL — 커리큘럼내에서의 순서, (id, 훈련순서) uniuque
  • created_at — timestamp — NOT NULL
  • started_at — timestamp
  • finished_at — timestamp
  • status — varchar(20) — NOT NULL — Enum: NOT_READY, NOT_STARTED, IN_PROGRESS, COMPLETED
  • result — json — 문항별 정답유무/틀린부분
  • accuracy — int — AI가 훈련결과JSON으로 판단한 정확도(0~1000)

word_attempt_logs

  • id — bigint — Primary key — NOT NULL
  • student_id — bigint — Foreign key → students.id — NOT NULL
  • word_id — bigint — NOT NULL — 단어는 기본형태
  • story_line_id — bigint
  • training_id — bigint
  • test_id — bigint
  • use_location — varchar(10) — NOT NULL
  • surface_text — varchar(50) — 단어의 문장내에서의 형태(ex: 먹었다)
  • has_gaze_data — boolean — NOT NULL
  • has_audio_data — boolean — NOT NULL
  • fixation_duration_ms — int
  • fixation_count — int
  • gaze_start_offset_ms — int
  • gaze_end_offset_ms — int
  • is_skipped — boolean
  • regression_count — int
  • recognized_text — varchar(255) — stt가 인식한 결과
  • speech_start_offset_ms — int
  • speech_end_offset_ms — int
  • is_correct — boolean
  • created_at — timestamp
  • total_score — int — 지표를 통해 계산한 단어의 점수 0~1000

word_categories

  • id — bigint — Primary key — NOT NULL
  • word_id — bigint — Foreign key → words.id — NOT NULL
  • category_name — varchar(50) — NOT NULL — Enum: 받침없는단어, ㅆ받침단어 etc // index

words

  • id — bigint — Primary key — NOT NULL — 단어는 기본형태
  • content — varchar(50) — NOT NULL — UNIQUE
  • length — int — NOT NULL