Janady13/missionmatch / db/migrations/0017_ai_memory.sql

Source identity

Field	Recorded value
Source type	GitHub source
Original record	Janady13/missionmatch / db/migrations/0017_ai_memory.sql
Date	Not specified in source
Repository	Janady13/missionmatch
Revision	720d47fae476b0d38477ae4401697d372b1ea2bc
Branch	feature/opportunity-to-outcome
Path or archive member	db/migrations/0017_ai_memory.sql
Original SHA-256	a0cb0f3f74053765d1136a12c937540b78e6c43fe0dcfa6b3fbfb40ebdcb95f7
Git blob SHA	0e1811d84da25f6cc60efc439f6f81f9181cbd27
Reading-copy SHA-256	a0cb0f3f74053765d1136a12c937540b78e6c43fe0dcfa6b3fbfb40ebdcb95f7

Original source ↗

Every recorded occurrence

These 25 records contain identical original source bytes. Their paths and revisions remain part of the archive.

Original record	Branch or archive	Revision / identifier	Original location
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	feature/opportunity-to-outcome	720d47fae476b0d38477ae4401697d372b1ea2bc	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	per-tenant-routing	9bde0f9a74b89d01980fa658e5253acda7528d0c	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	collision-deconfliction	4ee5a09972608ed89f8377c6665542d5f450f0a6	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	ws6-retrieval	6c56e29231ec05735927fa265c97d517499dfeaf	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	m5-price-to-win	41000ad30fff4129fdaf5ec84e15ba14c27d4890	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	ws1-ontology-sync	b596f449a32a1016fbd403c36505cc00a1ac9ee6	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	master	1e9249840a4302ec82e123b9c9cb6f75badea3e4	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	ws8-teaching-loop	c823f0fb6bb2aba0f39001eb6de96f4000d9321f	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	w3-ai-staffing-recommendations	43d56387270ef4da4cabd794d97ca6a49909bc7d	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	mag-substrate	b82c7100a492dec67dfd1eda6b3f53def859be35	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	ws3-clearance	4b8e7ce594c068621867f9c9deed0ec64ae6c553	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	phase2-eval-fairness	d361af254701975fe239927656ababb56374655e	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	time-to-fill-survival	b66e1e505863d4f17741a4b9ede73509e45bd6c6	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	ai-intelligence-layer	5d5ddff70393a197c5f54a45280bb5dd42b24755	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	graphrag-foundation	b0ddeb9f633fd138d09309d1a17b7d13bc3a67f7	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	deploy-and-ops	bdacd9d0b4d5998d25fc74bf4007f4c3ec538c7a	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	ws9-bench-ingestion	f585a9ef32fa554663ce1fba9a414a54b6e49cf0	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	ws2-alias-relationship	e4dada4601c6eb101830f9d223a9655dfa120616	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	presentation-readiness	eb574acaa29d71ce4d0f852572e87c275c79fdb7	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	vendor-intelligence	fe9796a19c261951d3f2565206c0c1b5ac294465	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	ws7-federal-signal	6a9f6ce9cfb13345ffb47770d4960e7c2d9c17c2	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	ai-brain-live	aac32fc49c878cc5bca099459307611562d0bac1	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	phase2-connectors	e038d4c687aec16f8bd9bc4d907eea14d91f8704	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	feature/aioe-upgrade	2178e7298d0e5d9af83afa12402fd587f0ba6ed8	Open original
Janady13/missionmatch / db/migrations/0017_ai_memory.sql	capture-readiness	bae6af7cb2997e819174a9e9cfff5e16067a1975	Open original

Recovered source transcript

Download complete source text ↓37 lines · 2.3 KB

-- +goose Up
-- ai_memory is the per tenant episodic and semantic memory for the AI layer. It lives INSIDE the tenant
-- database (database per tenant), so one client's memory is physically isolated from another's, and it
-- is RLS forced as defense in depth. Memory that is about a candidate carries candidate_id so the right
-- to erasure wipes it: when a candidate is anonymized, their memory rows are deleted, leaving no semantic
-- trace. The embedding column lets semantic memory be recalled by similarity; it is vector(384) to match
-- the one embedding model the platform uses. No demographic data ever enters this table (the AI layer is
-- barred from the eeo schema by construction).
CREATE TABLE ai_memory (
    id              uuid PRIMARY KEY DEFAULT gen_random_uuid(),
    organization_id uuid NOT NULL,
    candidate_id    uuid,                       -- set when the memory is about a candidate (for erasure)
    kind            text NOT NULL CHECK (kind IN ('episodic', 'semantic')),
    content         text NOT NULL,              -- a craft note or a recalled fact; never demographic data
    embedding       vector(384),                -- optional, for semantic recall
    created_at      timestamptz NOT NULL DEFAULT now(),
    updated_at      timestamptz NOT NULL DEFAULT now(),
    -- A candidate scoped memory references the candidate in the SAME org; if a candidate row is ever hard
    -- deleted the link is nulled rather than orphaned. Erasure (anonymize in place) deletes these rows
    -- explicitly, since anonymize does not delete the candidate row.
    CONSTRAINT fk_ai_memory_candidate FOREIGN KEY (organization_id, candidate_id)
        REFERENCES candidates (organization_id, id) ON DELETE SET NULL
);
CREATE INDEX idx_ai_memory_org_candidate ON ai_memory (organization_id, candidate_id);
CREATE INDEX idx_ai_memory_emb_hnsw ON ai_memory USING hnsw (embedding vector_cosine_ops) WHERE embedding IS NOT NULL;

ALTER TABLE ai_memory ENABLE ROW LEVEL SECURITY;
ALTER TABLE ai_memory FORCE  ROW LEVEL SECURITY;
CREATE POLICY ai_memory_isolation ON ai_memory
    USING      (organization_id = NULLIF(current_setting('app.current_org_id', true), '')::uuid)
    WITH CHECK (organization_id = NULLIF(current_setting('app.current_org_id', true), '')::uuid);

GRANT SELECT, INSERT, UPDATE, DELETE ON ai_memory TO missionmatch_app;

-- +goose Down
DROP TABLE IF EXISTS ai_memory;