dellweb3's picture
Work OS validated demo local-v0.8
99caad5 verified
Raw History Blame Contribute Delete
5.71 kB
"""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)