자율
테이블 (11)
approval_requests
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- device_id — BIGINT — 외래 키 → devices.id
- task_id — BIGINT — 외래 키 → tasks.id
- approval_type — VARCHAR(64) — NOT NULL
- status — VARCHAR(32) — NOT NULL
- request_payload — JSON
- response_payload — JSON
- resolved_at — DATETIME
device_events
- id — BIGINT — 기본 키 — NOT NULL
- device_id — BIGINT — 외래 키 → devices.id — NOT NULL
- task_id — BIGINT — 외래 키 → tasks.id
- event_type — VARCHAR(80) — NOT NULL
- payload — JSON
- occurred_at — DATETIME
devices
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- device_type — VARCHAR(32) — NOT NULL
- name — VARCHAR(120) — NOT NULL
- status — VARCHAR(32) — NOT NULL
- runtime_type — VARCHAR(50)
- runtime_version — VARCHAR(80)
- capabilities — JSON
- last_seen_at — DATETIME
health_consents
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- provider — VARCHAR(64) — NOT NULL
- consented — BOOLEAN — NOT NULL
- scopes — JSON
- last_synced_at — DATETIME
health_daily_summaries
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- summary_date — DATE — NOT NULL
- sleep_minutes — INT
- steps — INT
- exercise_minutes — INT
- average_heart_rate — INT
- summary — JSON
messages
- id — BIGINT — 기본 키 — NOT NULL
- session_id — BIGINT — 외래 키 → sessions.id — NOT NULL
- sender_type — VARCHAR(32) — NOT NULL
- content — TEXT — NOT NULL
- metadata — JSON
reminders
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- task_id — BIGINT — 외래 키 → tasks.id
- title — VARCHAR(200) — NOT NULL
- reminder_type — VARCHAR(32) — NOT NULL
- scheduled_at — DATETIME — NOT NULL
- status — VARCHAR(32) — NOT NULL
- channels — JSON
sessions
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- title — VARCHAR(200)
- status — VARCHAR(32) — NOT NULL
- summary — TEXT
- last_message_at — DATETIME
task_events
- id — BIGINT — 기본 키 — NOT NULL
- task_id — BIGINT — 외래 키 → tasks.id — NOT NULL
- event_type — VARCHAR(80) — NOT NULL
- message — TEXT
- payload — JSON
tasks
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- session_id — BIGINT — 외래 키 → sessions.id
- device_id — BIGINT — 외래 키 → devices.id
- task_type — VARCHAR(64) — NOT NULL
- status — VARCHAR(32) — NOT NULL
- progress_percent — TINYINT — NOT NULL
- input_text — TEXT
- result_text — TEXT
- error_message — TEXT
- started_at — DATETIME
- finished_at — DATETIME
users
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255)
- nickname — VARCHAR(100) — NOT NULL
- profile — JSON