File size: 5,613 Bytes
3e1cbf3
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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
128
129
130
131
132
133
134
135
136
137
138
139
140
141
"""Lược đồ dữ liệu — thay cho Neo4j, lưu luật + hiệu lực + sửa đổi trong Postgres.

Mã node theo kiểu LAWGIC: `blld2019-d35-k2-a`
  d = Điều, k = Khoản, chữ cái cuối = Điểm.
"""

from __future__ import annotations

from datetime import date, datetime

from pgvector.sqlalchemy import Vector
from sqlalchemy import (
    Date,
    DateTime,
    Float,
    ForeignKey,
    Integer,
    String,
    Text,
    func,
)
from sqlalchemy.orm import Mapped, mapped_column, relationship

from app.config import get_settings
from app.db.base import Base

EMBED_DIM = get_settings().embed_dim


class LegalDocument(Base):
    __tablename__ = "legal_document"

    doc_id: Mapped[str] = mapped_column(String(64), primary_key=True)
    title: Mapped[str] = mapped_column(Text)
    doc_type: Mapped[str | None] = mapped_column(String(32))  # luat|nghi_dinh|thong_tu|...
    number: Mapped[str | None] = mapped_column(String(64))
    issued_date: Mapped[date | None] = mapped_column(Date)
    effective_date: Mapped[date | None] = mapped_column(Date)
    expired_date: Mapped[date | None] = mapped_column(Date)
    status: Mapped[str | None] = mapped_column(String(32), default="active")
    source_url: Mapped[str | None] = mapped_column(Text)
    created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())

    nodes: Mapped[list["LegalNode"]] = relationship(back_populates="document")


class LegalNode(Base):
    __tablename__ = "legal_node"

    node_id: Mapped[str] = mapped_column(String(96), primary_key=True)
    doc_id: Mapped[str] = mapped_column(ForeignKey("legal_document.doc_id", ondelete="CASCADE"))
    level: Mapped[str] = mapped_column(String(16))  # article|clause|point
    article_no: Mapped[int | None] = mapped_column(Integer)
    clause_no: Mapped[int | None] = mapped_column(Integer)
    point_letter: Mapped[str | None] = mapped_column(String(4))
    parent_id: Mapped[str | None] = mapped_column(
        ForeignKey("legal_node.node_id", ondelete="CASCADE")
    )
    heading: Mapped[str | None] = mapped_column(Text)  # tiêu đề Điều
    text: Mapped[str] = mapped_column(Text)
    text_hash: Mapped[str | None] = mapped_column(String(64))
    seq: Mapped[int | None] = mapped_column(Integer)  # thứ tự trong văn bản
    effective_from: Mapped[date | None] = mapped_column(Date)
    effective_to: Mapped[date | None] = mapped_column(Date)
    embedding: Mapped[list[float] | None] = mapped_column(Vector(EMBED_DIM))

    document: Mapped["LegalDocument"] = relationship(back_populates="nodes")


class NodeSupersession(Base):
    """Quan hệ SUPERSEDED_BY: node cũ bị node mới thay thế."""

    __tablename__ = "node_supersession"

    old_id: Mapped[str] = mapped_column(
        ForeignKey("legal_node.node_id", ondelete="CASCADE"), primary_key=True
    )
    new_id: Mapped[str] = mapped_column(
        ForeignKey("legal_node.node_id", ondelete="CASCADE"), primary_key=True
    )
    change_type: Mapped[str | None] = mapped_column(String(32))  # amended|replaced|removed|added
    similarity: Mapped[float | None] = mapped_column(Float)
    detected_at: Mapped[datetime] = mapped_column(
        DateTime(timezone=True), server_default=func.now()
    )


class DocumentRelation(Base):
    """Quan hệ cấp văn bản: AMENDS / REPLACES / GUIDES."""

    __tablename__ = "document_relation"

    from_doc: Mapped[str] = mapped_column(
        ForeignKey("legal_document.doc_id", ondelete="CASCADE"), primary_key=True
    )
    to_doc: Mapped[str] = mapped_column(
        ForeignKey("legal_document.doc_id", ondelete="CASCADE"), primary_key=True
    )
    rel: Mapped[str] = mapped_column(String(16), primary_key=True)


class Precedent(Base):
    """Án lệ / bản án (tòa án) — nguồn cho nhánh tổng hợp án lệ (M6b)."""

    __tablename__ = "precedent"

    doc_name: Mapped[str] = mapped_column(String(128), primary_key=True)
    title: Mapped[str | None] = mapped_column(Text)
    court: Mapped[str | None] = mapped_column(Text)
    court_level: Mapped[str | None] = mapped_column(String(64))
    precedent_number: Mapped[str | None] = mapped_column(String(64))
    is_precedent: Mapped[bool | None] = mapped_column()
    category: Mapped[str | None] = mapped_column(String(128))
    issued_date: Mapped[date | None] = mapped_column(Date)
    citations_law: Mapped[str | None] = mapped_column(Text)  # JSON/text các luật được viện dẫn
    source_url: Mapped[str | None] = mapped_column(Text)
    text: Mapped[str] = mapped_column(Text)  # markdown bản án
    embedding: Mapped[list[float] | None] = mapped_column(Vector(EMBED_DIM))


class Thread(Base):
    __tablename__ = "thread"

    id: Mapped[str] = mapped_column(String(64), primary_key=True)
    title: Mapped[str | None] = mapped_column(Text)
    created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())
    updated_at: Mapped[datetime] = mapped_column(
        DateTime(timezone=True), server_default=func.now(), onupdate=func.now()
    )


class Message(Base):
    __tablename__ = "message"

    id: Mapped[int] = mapped_column(Integer, primary_key=True, autoincrement=True)
    thread_id: Mapped[str] = mapped_column(ForeignKey("thread.id", ondelete="CASCADE"))
    role: Mapped[str] = mapped_column(String(16))  # human|ai|tool
    content: Mapped[str] = mapped_column(Text)
    meta: Mapped[str | None] = mapped_column(Text)  # JSON (citations, tool calls)
    created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())