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