무드팔레트

테이블 (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