RAG-api / app /db /models.py
Minh Be
deploy FastAPI backend
3e1cbf3
Raw History Blame Contribute Delete
5.61 kB
"""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())