hanal2

Tables (7)

LearningMission

  • id — BIGINT — Primary key — NOT NULL
  • status — ENUM('CREATED', 'IN_PROGRESS', 'COMPLETED') — NOT NULL
  • mission_type — TINYINT
  • past_missions — JSON
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • meaning_id (id2) — BIGINT — Foreign key → Meaning.meaning_id — NOT NULL
  • word_id (id3) — BIGINT — Foreign key → Word.id — NOT NULL
  • user_id (id4) — BIGINT — Foreign key → User.user_id — NOT NULL

Meaning

  • meaning_id (id) — BIGINT — Primary key — NOT NULL
  • word_meaning — TEXT — NOT NULL
  • word_ex_sentence — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — `idx_word_id`
  • word_id (id2) — BIGINT — Foreign key → Word.id — NOT NULL

MissionMessage

  • id — BIGINT — Primary key — NOT NULL
  • mission_id — BIGINT — NOT NULL
  • message_order — INT — NOT NULL
  • sender — ENUM('user', 'chatbot') — NOT NULL
  • message_content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • INDEX — `idx_mission_order`

Point

  • user_id (id2) — BIGINT — Foreign key → User.user_id — NOT NULL
  • user_point — INT — NOT NULL

User

  • user_id (id) — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • user_name — VARCHAR(100)
  • user_job — VARCHAR(255)
  • user_age — INT
  • user_profile — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — `idx_email`

UserWordCount

  • user_id (id2) — BIGINT — Foreign key → User.user_id — NOT NULL
  • word_cnt — INT — NOT NULL

Word

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • word — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — `idx_user_id`
  • INDEX — `idx_word`