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

from sqlalchemy import Column, Integer, String
from app.database import Base
from sqlalchemy.orm import relationship

class CaseEntity(Base):
    __tablename__ = "case_entity"

    id = Column(Integer, primary_key=True)
    number = Column(String(100), nullable=False, unique=True)

    documents = relationship("Document", back_populates="case_entity")
    audio_recordings = relationship("AudioRecording", back_populates="case_entity")

    def __repr__(self):
        return f"<CaseEntity(id={self.id}, number='{self.number}')>"