Member Junction
    Preparing search index...

    Describes the physical target a query runs against — the sibling table MJ manages, or an existing VECTOR column on an entity table (the migration shape for systems that already store embeddings on their own tables).

    interface SqlServerIndexTarget {
        filterMode: "jsonMetadata" | "column";
        keyColumn: string;
        qualifiedTable: string;
        selectColumns: readonly string[];
        vectorColumn: string;
    }
    Index

    Properties

    filterMode: "jsonMetadata" | "column"

    How a filter field resolves to SQL: JSON on the metadata column, or a live entity column.

    keyColumn: string

    The key/id column projected as id (sibling: id; entityColumn: e.g. ID).

    qualifiedTable: string

    Schema-qualified table the vectors live in, already bracket-quoted (e.g. [__mj].[vec_x]).

    selectColumns: readonly string[]

    Extra columns returned with each match (sibling: ['metadata']; entityColumn: entity cols).

    vectorColumn: string

    The VECTOR column name (sibling: embedding; entityColumn: e.g. Embedding).