ReachyMini_11tables

Tables (10)

conversation_sessions

  • id — UUID
  • user_id — UUID — Foreign key → users.id
  • session_id — VARCHAR(100) — NOT NULL
  • started_at — TIMESTAMPTZ — NOT NULL
  • ended_at — TIMESTAMPTZ
  • summary — TEXT
  • turn_count — INTEGER
  • created_at — TIMESTAMPTZ

conversation_turns

  • id — UUID
  • conversation_session_id — UUID — Foreign key → conversation_sessions.id
  • turn_index — INTEGER — NOT NULL
  • role — VARCHAR(10) — NOT NULL
  • content — TEXT — NOT NULL
  • emotion — VARCHAR(20)
  • tool_calls — JSONB
  • created_at — TIMESTAMPTZ

current_session_turns

  • id — INTEGER
  • session_id — TEXT — NOT NULL
  • turn_index — INTEGER — NOT NULL
  • role — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • emotion — TEXT
  • tool_calls — TEXT
  • created_at — TEXT

daily_summaries

  • id — UUID
  • user_id — UUID — Foreign key → users.id
  • log_date — DATE — NOT NULL
  • summary — TEXT
  • mood — VARCHAR(20)
  • mood_score — FLOAT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • UNIQUE(user_id, — log_date)

memory_embeddings

  • id — UUID
  • source_table — VARCHAR(50) — NOT NULL
  • source_id — UUID — NOT NULL
  • chunk_text — TEXT — NOT NULL
  • chunk_index — INTEGER
  • embedding — vector(1536)
  • created_at — TIMESTAMPTZ

memory_facts

  • id — UUID
  • user_id — UUID — Foreign key → users.id
  • category — VARCHAR(50) — NOT NULL
  • fact_text — TEXT — NOT NULL
  • source — VARCHAR(20)
  • confidence — FLOAT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

memory_facts_cache

  • id — TEXT
  • user_id — TEXT — NOT NULL
  • category — TEXT — NOT NULL
  • fact_text — TEXT — NOT NULL
  • confidence — REAL
  • synced_at — TEXT

sync_queue

  • id — INTEGER
  • target_table — TEXT — NOT NULL
  • operation — TEXT — NOT NULL
  • payload — TEXT — NOT NULL
  • created_at — TEXT
  • synced_status — INTEGER
  • retry_count — INTEGER
  • max_retries — INTEGER
  • last_error — TEXT
  • last_attempted_at — TEXT

user_cache

  • id — TEXT
  • device_id — TEXT — NOT NULL
  • name — TEXT
  • nickname — TEXT
  • birth_date — TEXT
  • gender — TEXT
  • settings — TEXT
  • synced_at — TEXT

users

  • id — UUID
  • device_id — VARCHAR(100) — NOT NULL
  • name — VARCHAR(100)
  • nickname — VARCHAR(100)
  • birth_date — DATE
  • gender — VARCHAR(10)
  • settings — JSONB
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ