pudding
Tables (11)
Challenge_Answers
- answer_id (PK) — INT — Primary key
- uuid — INT — Foreign key → User.uuid
- daily_challenge_id — INT — Foreign key → Daily_Challenge.daily_challenge_id
- user_answer — TEXT
- korean_sentence — TEXT
- english_sentence — TEXT
- feedback — TEXT
- is_correct — BOOLEAN
Chunks
- chunk_id — INT — Primary key
- korean_sentence — TEXT
- english_sentence — TEXT
- created_date — DATE
- beginner_chunk — TEXT
- intermediate_chunk — TEXT
- advanced_chunk — TEXT
Daily_Challenge
- daily_challenge_id (PK) — INT — Primary key
- uuid — INT — Foreign key → User.uuid
- start_time — TIMESTAMP
- end_time — TIMESTAMP
Dialog_Answers
- answer_id (PK) — INT — Primary key
- uuid — INT — Foreign key → User.uuid
- session_id — INT — Foreign key → Session.session_id
- situation — VARCHAR(255) — Foreign key → Session.situation
- user_answer — TEXT
- korean_sentence — TEXT
- english_sentence — TEXT
- feedback — TEXT
- is_correct — BOOLEAN
Dialog_Korean (Untitled)
- dialog_id (PK) — INT — Foreign key → Dialog_Situation.dialog_id
- situation (Field)
- description (korean)
- pic (path)
Dialog_Situation
- dialog_id (PK) — INT — Primary key
- situation — VARCHAR(255) — Primary key
Session
- session_id (PK) — INT — Primary key
- uuid — INT — Foreign key → User.uuid
- situation — VARCHAR(255) — Foreign key → Dialog_Situation.situation
- dialog_id — INT
- dialog_file — VARCHAR(255)
- start_time — TIMESTAMP
- end_time — TIMESTAMP
Test_Answers
- test_answers_id (PK) — INT — Primary key
- uuid — INT — Foreign key → User.uuid
- created_date — DATE
- beginner_answers — TEXT
- intermediate_answers — TEXT
- advanced_answers — TEXT
Test_Results
- test_result_id (PK) — INT — Primary key
- uuid — INT — Foreign key → User.uuid
- test_sentences_id (PK2) — INT — Foreign key → Test_Sentences.test_sentences_id
- test_answers_id (PK3) — INT — Foreign key → Test_Answers.test_answers_id
- test_date — DATE
- at_user_level — ENUM('A1', 'A2', 'overB1')
- test_score — INT
Test_Sentences
- test_sentences_id (PK) — INT — Primary key
- created_date — DATE
- beginner_sentences — TEXT
- intermediate_sentences — TEXT
- advanced_sentences — TEXT
User
- uuid (PK) — VARCHAR(36) — Primary key
- oAuth_email — VARCHAR(255)
- username — VARCHAR(255)
- snsType — VARCHAR(50)
- user_level — ENUM('null', '초급', '중급', '고급')
- chunk_level — ENUM('null', '없음', '초급', '중급', '고급')
- created_at — TIMESTAMP
- last_login — TIMESTAMP