glejam
Tables (13)
HanjaCharacter (한자)
- ID (키) — INT — Primary key — NOT NULL
- order (오늘의 단어 내에서의 순서) — INT
- hanja_word_id (한자 단어 키) — INT — Foreign key → HanjaWord.ID — NOT NULL
HanjaLearningContent (한자 학습 데이터)
- ID (키) — INT — Foreign key → Learning.ID — NOT NULL
- hanja_word_id (한자 단어 키) — INT — Foreign key → HanjaWord.ID — NOT NULL
HanjaLearningUnit (한자 학습의 문항)
- ID (키) — INT — Primary key — NOT NULL
- is_answerd (제출여부) — BOOLEAN
- answered_at (제출시각) — TIMESTAMP
- answered_correct (정답 여부) — BOOLEAN
- hanja_learning_content_id (fk) — INT — Foreign key → HanjaLearningContent.ID — NOT NULL
- hanja_unit_id (fk2) — INT — Foreign key → HanjaUnit.ID — NOT NULL
HanjaUnit (한자 문항 모음집)
- ID (키) — INT — Primary key — NOT NULL
- is_answerd (제출여부) — BOOLEAN
- answered_at (제출시각) — TIMESTAMP
- answered_correct (정답 여부) — BOOLEAN
HanjaWord (한자 단어)
- ID (키) — INT — Primary key — NOT NULL
- Field
Learning (학습)
- ID (키) — INT — Primary key — NOT NULL
- content_type (컨텐츠 타입) — VARCHAR
- type (학습 종류) — VARCHAR
- totalUnit (전체 문항) — INT
- totalCorrect (전체 문항 중 정답의 수) — INT
- totalSubmit (전체 제출 수) — INT
- level (학습 레벨) — VARCHAR
LearningAnswer (학습의 정답)
- ID (키) — INT — Primary key — NOT NULL
- learning_key (fk) — INT — Foreign key → Learning.ID — NOT NULL
- is_correct (정답 여부) — BOOLEAN
- answer (제출 데이터) — ???
- passage_learning_id (지문학습의 문항의 ID) — INT
Passage (지문)
- ID (키) — INT — Primary key — NOT NULL
- Field
PassageLearningContent (지문 학습 데이터)
- ID (키) — INT — Foreign key → Learning.ID — NOT NULL
- paasage_id (키2) — INT — Foreign key → Passage.ID — NOT NULL
PassageLearningContentWord (지문 학습 데이터 속의 단어)
- ID (키) — INT — Primary key — NOT NULL
- passage_learning_content_id (키2) — INT — Foreign key → PassageLearningContent.ID — NOT NULL
- passge_word_id (키3) — INT — Foreign key → PassageWord.ID — NOT NULL
PassageLearningUnit (지문 학습의 문항)
- ID (키) — INT — Primary key — NOT NULL
- passage_unit_id (fk) — INT — Foreign key → PassageUnit.ID — NOT NULL
- passage_learning_content_id (키2) — INT — Foreign key → PassageLearningContent.ID — NOT NULL
- is_answerd (제출여부) — BOOLEAN
- answered_at (제출시각) — TIMESTAMP
- answered_correct (정답 여부) — BOOLEAN
PassageUnit (지문 문항의 모음집)
- ID (키) — INT — Primary key — NOT NULL
- order (순서) — INT
- data (데이터) — ????
- passage_id (키2) — INT — Foreign key → Passage.ID — NOT NULL
- type (문항의 종류) — VARCHAR
PassageWord (지문 단어)
- ID (키) — INT — Primary key — NOT NULL
- passage_id (키2) — INT — Foreign key → Passage.ID — NOT NULL