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`