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)