---
title: "Entity relationship diagram"
manual: "AI Assistant"
version: "main"
source: "Developers/DataModel/EntityRelationshipDiagram.rst"
rendered: "2026-10-03T14:54:45+00:00"
---

# Entity relationship diagram {#entity-relationship-diagram}

The following diagram is intentionally abstract. It shows the relationships that
are relevant for understanding the extension, not every database field.

```mermaid
erDiagram
    AI_CONNECTION ||--o{ ASSISTANT_PROFILE : used_by
    VECTOR_STORE_CONNECTION ||--o{ ASSISTANT_PROFILE : used_by
    ASSISTANT_PROFILE ||--o{ PIPELINE_STEP : contains
    AI_CONNECTION ||--o{ INDEXER_CONFIG : creates_embeddings
    VECTOR_STORE_CONNECTION ||--o{ INDEXER_CONFIG : stores_vectors
    INDEXER_CONFIG ||--o{ INDEXER_RUN : creates
    INDEXER_CONFIG ||--o{ INDEXER_SOURCE : tracks
    ASSISTANT_PROFILE ||--o{ PIPELINE_TRACE : writes
    PIPELINE_STEP ||--o{ PIPELINE_TRACE : writes
```

## Conceptual tables {#conceptual-tables}

-   **Assistant configuration**

    Assistant profiles and pipeline steps.

-   **Connection configuration**

    AI and vector store connections.

-   **Indexing configuration**

    Indexer configurations, external connector settings, indexer runs and source
    states.

-   **Runtime diagnostics**

    Pipeline traces and backend diagnostics.