푸딩
테이블 (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)