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