무드팔레트
테이블 (7)
diary_emotions
- emotion_id — BIGINT
- entry_id — BIGINT — 외래 키 → diary_entries.entry_id — NOT NULL
- emotion_label — VARCHAR(30) — NOT NULL
- score — DECIMAL(5,4) — NOT NULL
- created_at — DATETIME
diary_entries
- entry_id — BIGINT
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- entry_date — DATE — NOT NULL
- content — TEXT — NOT NULL
- primary_emotion — VARCHAR(30)
- primary_score — DECIMAL(5,4)
- created_at — DATETIME
- updated_at — DATETIME
diary_images
- image_id — BIGINT
- entry_id — BIGINT — 외래 키 → diary_entries.entry_id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- prompt — TEXT
- image_url — VARCHAR(500)
- error_message — VARCHAR(500)
- requested_at — DATETIME
- started_at — DATETIME
- completed_at — DATETIME
diary_keywords
- keyword_id — BIGINT
- entry_id — BIGINT — 외래 키 → diary_entries.entry_id — NOT NULL
- keyword — VARCHAR(50) — NOT NULL
- weight — DECIMAL(6,4)
- created_at — DATETIME
notifications
- notification_id — BIGINT
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- type — VARCHAR(20) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- message — VARCHAR(500) — NOT NULL
- entry_id — BIGINT — 외래 키 → diary_entries.entry_id
- letter_id — BIGINT — 외래 키 → timecapsule_letters.letter_id
- is_read — BOOLEAN
- created_at — DATETIME
- read_at — DATETIME
timecapsule_letters
- letter_id — BIGINT
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- open_at — DATETIME — NOT NULL
- opened_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
users
- user_id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME