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