app/models/document_file.py - master - tsps/core

from sqlalchemy import Column, Integer, String, LargeBinary, Integer, DateTime, ForeignKey
from sqlalchemy.sql import func
from sqlalchemy.orm import relationship
from app.database import Base

class DocumentFile(Base):
    __tablename__ = "document_file"

    id = Column(Integer, primary_key=True)
    document_id = Column(Integer, ForeignKey("document.id", ondelete="CASCADE"), nullable=False, unique=True)
    file_data = Column(LargeBinary, nullable=False)  # аналог bytea в PostgreSQL
    file_size = Column(Integer, nullable=False)
    mime_type = Column(String(100), nullable=False, default="application/pdf")
    uploaded_at = Column(DateTime, server_default=func.now(), nullable=False)

    document = relationship("Document", back_populates="document_file")

    def __repr__(self):
        return f"<DocumentFile(id={self.id}, doc_id={self.document_id}, size={self.file_size})>"