피우다프로젝트_시니어스(최종)
테이블 (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