MoodSignal

Tables (8)

content_tags

  • id — BIGSERIAL
  • content_id — BIGINT — Foreign key → healing_contents.id — NOT NULL
  • tag — VARCHAR(50) — NOT NULL

daily_summaries

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • date — DATE — NOT NULL
  • avg_valence — FLOAT — NOT NULL
  • avg_arousal — FLOAT — NOT NULL
  • avg_heart_rate — FLOAT — NOT NULL
  • min_heart_rate — FLOAT — NOT NULL
  • max_heart_rate — FLOAT — NOT NULL
  • dominant_mood — VARCHAR(20) — NOT NULL
  • data_count — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

emotion_records

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • ppg_reading_id — BIGINT — Foreign key → ppg_readings.id
  • valence — FLOAT — NOT NULL
  • arousal — FLOAT — NOT NULL
  • mood_label — VARCHAR(20) — NOT NULL
  • heart_rate_avg — FLOAT — NOT NULL
  • analyzed_at — TIMESTAMPTZ — NOT NULL

healing_contents

  • id — BIGSERIAL
  • type — VARCHAR(20) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • thumbnail_url — VARCHAR(500)
  • is_editors_pick — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

ppg_readings

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • heart_rate — FLOAT — NOT NULL
  • raw_signal — JSONB
  • recorded_at — TIMESTAMPTZ — NOT NULL

recommendations

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • emotion_record_id — BIGINT — Foreign key → emotion_records.id
  • content_id — BIGINT — Foreign key → healing_contents.id — NOT NULL
  • reason_text — TEXT
  • recommended_at — TIMESTAMPTZ — NOT NULL

users

  • id — BIGSERIAL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • auth_provider — VARCHAR(10) — NOT NULL
  • provider_id — VARCHAR(255)
  • notification_enabled — BOOLEAN — NOT NULL
  • theme — VARCHAR(10) — NOT NULL
  • joined_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

weekly_insights

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • week_start_date — DATE — NOT NULL
  • comment_title — VARCHAR(100) — NOT NULL
  • comment_body — TEXT — NOT NULL
  • generated_at — TIMESTAMPTZ — NOT NULL