푸딩

테이블 (5)

DIALOG_ANSWERS (Untitled4)

  • answer_id (PK) — 기본 키 — NOT NULL
  • user_id — 외래 키 → USER.user_id — NOT NULL
  • session_id — 외래 키 → DIALOG_SESSION.session_id — NOT NULL
  • user_answer (Field)
  • korean_sentence (Field2)
  • english_answer (Field3)
  • feedback (Field4)
  • is_correct (Field5)

DIALOG_SESSION (Untitled3)

  • session_id (PK) — 기본 키 — NOT NULL
  • user_id — 외래 키 → USER.user_id — NOT NULL
  • dialog_id — 외래 키 → DIALOG_SITUATION.dialog_id — NOT NULL
  • start_time (Field)
  • end_time (Field2)

DIALOG_SITUATION (Untitled2)

  • dialog_id (PK) — 기본 키 — NOT NULL
  • situation (Field)

TEST_SENTENCES (Untitled5)

  • test_sentences_id (PK) — 기본 키 — NOT NULL
  • created_date (Field)
  • beginner_sentences (Field2)
  • intermediate_sentences (Field3)
  • advanced_sentences (Field4)

USER (Untitled)

  • user_id (PK) — 기본 키 — NOT NULL
  • oAuth_email (Field)
  • user_name (Field2)
  • snsType (Field3)
  • user_level (Field4)
  • chunk_level (Field5)
  • created_at (Field6)
  • last_login (Field7)