The full schema lives in sql/001_init.sql. Migrations after that point are Java classes under src/main/precompiled/ai/ownsona/migrations/.
memories table ¶Documented per-column in The memories table.
| Index | Type | Purpose |
|---|---|---|
memories_user_id_idx | B-tree | Per-user filter. |
memories_created_at_idx | B-tree | Listing newest first. |
memories_deleted_at_idx | B-tree | Tombstone filter. |
memories_tags_idx | GIN | Tag filter on tags. |
memories_text_trgm_idx | GIN | Trigram for text_search. |
memories_embedding_idx | HNSW | Cosine-similarity recall. |
memories_unique_normalized_active | Unique partial | Exact-duplicate prevention. |
db_version table ¶Created by DbMigrator on first startup.
| Column | Type | Purpose |
|---|---|---|
version | INT PRIMARY KEY | Migration’s target version. |
applied_at | TIMESTAMPTZ NOT NULL DEFAULT now() | When it ran. |
note | TEXT | Migration’s name(). |