-- Entity-aware search: embeddings of PROPERTY NAMES (one per active property).
-- A query like "apartment" rarely appears verbatim in transcripts, but it sits
-- near "Diamond Lake Apts" in embedding space — matched properties surface as
-- an entity strip above the transcript moments, with their meetings.

CREATE TABLE IF NOT EXISTS meeting_property_vectors (
    property_id varchar(32)  NOT NULL PRIMARY KEY,
    company     varchar(32)  NOT NULL,
    name        varchar(200) NOT NULL,
    vec         text         NOT NULL,
    created     timestamp    NOT NULL DEFAULT now()
);

CREATE INDEX idx_mpv_company ON meeting_property_vectors (company);
