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 SVGmarket_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.