자율

테이블 (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