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())
|