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