Data architecture

SQLite entities and Qdrant mappings

Generated from all versioned SQL migrations in an empty temporary database. The diagram contains schema only, with no customer records. Hover relationship lines for foreign-key names.

Mermaid ERD source and collection mappings · Open full-size SVGOpen database ERD

market_products

Point ID = SQL product_id. Payload category_id joins the SQL category. Revision, document hash and embedding model identify freshness.

customer_memories

Point ID = SQL memory_id. person_id, version and embedding_model filter recall, followed by SQL ownership and active/version checks.

FTS5 and durable jobs

product_fts.rowid logically matches product_id. Product index jobs deliberately retain deleted IDs for vector cleanup. These are logical links, not foreign keys.