피우다프로젝트_시니어스(최종)

테이블 (11)

ai_prompt_versions

  • id — BIGINT — 기본 키 — NOT NULL
  • prompt_type — VARCHAR(50) — NOT NULL
  • version — VARCHAR(30) — NOT NULL
  • content — TEXT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

app_users

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL
  • current_streak_days — INT — NOT NULL
  • last_recorded_date — DATE
  • is_deleted — TINYINT(1) — NOT NULL
  • deleted_at — DATETIME
  • last_login_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

daily_records

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → app_users.id — NOT NULL
  • record_date — DATE — NOT NULL
  • mood_type — VARCHAR(20) — NOT NULL
  • question_template_id — BIGINT — 외래 키 → question_templates.id
  • question_text — VARCHAR(255) — NOT NULL
  • personalized_keywords — JSON
  • status — VARCHAR(30) — NOT NULL
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

letters

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → app_users.id — NOT NULL
  • daily_record_id — BIGINT — 외래 키 → daily_records.id — NOT NULL
  • prompt_version_id — BIGINT — 외래 키 → ai_prompt_versions.id
  • content — TEXT
  • letter_date — DATE — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • is_read — TINYINT(1) — NOT NULL
  • read_at — DATETIME
  • fallback_used — TINYINT(1) — NOT NULL
  • generated_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

memories

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → app_users.id — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • value — TEXT — NOT NULL
  • confidence — DECIMAL(3,2) — NOT NULL
  • mention_count — SMALLINT — NOT NULL
  • source_voice_record_id — BIGINT — 외래 키 → voice_records.id
  • last_referenced_at — DATETIME
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notifications

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → app_users.id — NOT NULL
  • letter_id — BIGINT — 외래 키 → letters.id
  • type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • body — VARCHAR(255) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • scheduled_at — DATETIME — NOT NULL
  • sent_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

otp_logs

  • id — BIGINT — 기본 키 — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL
  • code — VARCHAR(10) — NOT NULL
  • purpose — VARCHAR(30) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • verified_at — DATETIME
  • created_at — DATETIME — NOT NULL

push_device_tokens

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → app_users.id — NOT NULL
  • device_token — VARCHAR(500) — NOT NULL
  • device_type — VARCHAR(30)
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

question_templates

  • id — BIGINT — 기본 키 — NOT NULL
  • mood_type — VARCHAR(20) — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

refresh_tokens

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → app_users.id — NOT NULL
  • token — VARCHAR(512) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

voice_records

  • id — BIGINT — 기본 키 — NOT NULL
  • daily_record_id — BIGINT — 외래 키 → daily_records.id — NOT NULL
  • user_id — BIGINT — 외래 키 → app_users.id — NOT NULL
  • audio_url — VARCHAR(500) — NOT NULL
  • duration_seconds — INT
  • stt_text — TEXT
  • summary — TEXT
  • keywords — JSON
  • analysis_status — VARCHAR(30) — NOT NULL
  • recorded_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL