Download app/db/models.py from minhbe65/RAG-api: direct link, hf CLI and curl.
- Browser
- Download file 5.61 kB
-
https://huggingface.co/spaces/minhbe65/RAG-api/resolve/main/app/db/models.py
- Command line
-
hf download hf://spaces/minhbe65/RAG-api/app/db/models.py
-
curl -L -o models.py https://huggingface.co/spaces/minhbe65/RAG-api/resolve/main/app/db/models.py
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()) | |