"""Knowledge-owned tables; immutable document versions and stable chunks.""" from sqlalchemy import JSON, Integer, String, Text, ForeignKey, UniqueConstraint, LargeBinary from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column class KnowledgeError(Exception): def __init__(self, status, code, message): self.status, self.code, self.message, self.details = status, code, message, {} super().__init__(message) class Base(DeclarativeBase): pass class KnowledgeBase(Base): __tablename__ = "kb_base" tenant: Mapped[str] = mapped_column(String(80), primary_key=True) id: Mapped[str] = mapped_column(String(80), primary_key=True) name: Mapped[str] = mapped_column(String(120)) visibility: Mapped[str] = mapped_column(String(24)) class Grant(Base): __tablename__ = "kb_grant" tenant: Mapped[str] = mapped_column(String(80), primary_key=True) base_id: Mapped[str] = mapped_column(String(80), primary_key=True) user_id: Mapped[str] = mapped_column(String(80), primary_key=True) class Document(Base): __tablename__ = "kb_document" id: Mapped[str] = mapped_column(String(80), primary_key=True) tenant: Mapped[str] = mapped_column(String(80), index=True) document_id: Mapped[str] = mapped_column(String(80)) version: Mapped[str] = mapped_column(String(40)) base_id: Mapped[str] = mapped_column(String(80)) title: Mapped[str] = mapped_column(String(255)) owner: Mapped[str | None] = mapped_column(String(80)) workspace: Mapped[str | None] = mapped_column(String(80)) source_type: Mapped[str] = mapped_column(String(32)) sha256: Mapped[str] = mapped_column(String(64)) status: Mapped[str] = mapped_column(String(24)) valid_from: Mapped[str | None] = mapped_column(String(10)) valid_to: Mapped[str | None] = mapped_column(String(10)) error_code: Mapped[str | None] = mapped_column(String(80)) created_at: Mapped[str] = mapped_column(String(40)) __table_args__ = (UniqueConstraint("tenant", "document_id", "version", name="uq_kb_document_version"),) class Chunk(Base): __tablename__ = "kb_chunk" id: Mapped[str] = mapped_column(String(80), primary_key=True) document_key: Mapped[str] = mapped_column(ForeignKey("kb_document.id"), index=True) ordinal: Mapped[int] = mapped_column(Integer) locator: Mapped[str] = mapped_column(String(255)) text: Mapped[str] = mapped_column(Text) terms: Mapped[list] = mapped_column(JSON) __table_args__ = (UniqueConstraint("document_key", "ordinal", name="uq_kb_chunk_ordinal"),) class TraceChunk(Base): __tablename__='trace_chunk' trace_id:Mapped[str]=mapped_column(String(80),primary_key=True) ordinal:Mapped[int]=mapped_column(Integer,primary_key=True) body:Mapped[dict]=mapped_column(JSON) class DocumentSource(Base): __tablename__='kb_document_source' document_key:Mapped[str]=mapped_column(ForeignKey('kb_document.id'),primary_key=True) body:Mapped[dict]=mapped_column(JSON) class LibraryConfig(Base): __tablename__ = "kb_library_config" tenant: Mapped[str] = mapped_column(String(80), primary_key=True) base_id: Mapped[str] = mapped_column(String(80), primary_key=True) description: Mapped[str] = mapped_column(Text, default="") category: Mapped[str] = mapped_column(String(80), default="综合办公") status: Mapped[str] = mapped_column(String(20), default="enabled") revision: Mapped[int] = mapped_column(Integer, default=1) class DocumentInfo(Base): __tablename__ = "kb_document_info" document_key: Mapped[str] = mapped_column(ForeignKey("kb_document.id"), primary_key=True) filename: Mapped[str] = mapped_column(String(255)) original: Mapped[bytes | None] = mapped_column(LargeBinary) tags: Mapped[list] = mapped_column(JSON, default=list) category: Mapped[str] = mapped_column(String(80), default="综合办公") publication: Mapped[str] = mapped_column(String(20), default="published") revision: Mapped[int] = mapped_column(Integer, default=1) class Audit(Base): __tablename__ = "kb_audit" id: Mapped[str] = mapped_column(String(80), primary_key=True) tenant: Mapped[str] = mapped_column(String(80), index=True) actor: Mapped[str] = mapped_column(String(80)) action: Mapped[str] = mapped_column(String(80)) resource: Mapped[str] = mapped_column(String(120)) detail: Mapped[dict] = mapped_column(JSON) created_at: Mapped[str] = mapped_column(String(40)) class ChatTurn(Base): __tablename__ = "chat_turn" tenant: Mapped[str] = mapped_column(String(80), primary_key=True) user_id: Mapped[str] = mapped_column(String(80), primary_key=True) workspace_id: Mapped[str] = mapped_column(String(80), primary_key=True) request_key: Mapped[str] = mapped_column(String(128), primary_key=True) fingerprint: Mapped[str] = mapped_column(String(64)) response: Mapped[dict] = mapped_column(JSON) class TraceRecord(Base): __tablename__ = "workos_trace" id: Mapped[str] = mapped_column(String(80), primary_key=True) tenant: Mapped[str] = mapped_column(String(80), index=True) owner: Mapped[str] = mapped_column(String(80)) workspace: Mapped[str | None] = mapped_column(String(80), index=True) run_id: Mapped[str | None] = mapped_column(String(80)) operation: Mapped[str] = mapped_column(String(255)) status: Mapped[str] = mapped_column(String(24)) duration_ms: Mapped[int] = mapped_column(Integer) started_at: Mapped[str] = mapped_column(String(40)) spans: Mapped[list] = mapped_column(JSON)