TPCF Agent VectorDB ERD
Tables (3)
document_chunks
- chunk_id — BIGINT — Primary key — NOT NULL
- document_id — BIGINT — Foreign key → documents.document_id — NOT NULL
- chunk_index — INT — NOT NULL
- chunk_text — TEXT
- vector_db_id — VARCHAR(100)
- vector_db_collection — VARCHAR(50)
- embedding_model — VARCHAR(50)
- created_at — DATETIME(6)
documents
- document_id — BIGINT — Primary key — NOT NULL
- source — VARCHAR(20) — NOT NULL
- external_id — VARCHAR(255) — NOT NULL
- title — VARCHAR(255)
- url — VARCHAR(500)
- version — VARCHAR(50)
- last_modified_at — DATETIME(6)
- last_synced_at — DATETIME(6)
- sync_status — VARCHAR(20)
- created_at — DATETIME(6)
- deleted_at — DATETIME(6)
message_sources
- source_id — CHAR(36) — Primary key — NOT NULL
- message_id — CHAR(36) — NOT NULL
- chunk_id — BIGINT — Foreign key → document_chunks.chunk_id — NOT NULL
- relevance_score — DECIMAL(5,4)
- created_at — DATETIME(6)