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