File size: 5,713 Bytes
99caad5
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
"""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)