NexLab_System / app /models /patient.py
alisaleem97's picture
Upload folder using huggingface_hub
6ea020b verified
Raw History Blame Contribute Delete
3.98 kB
# app/models/patient.py
# Patient, PatientVisit, and Attachment models.
from typing import Optional, List
from datetime import datetime
from sqlmodel import SQLModel, Field, Relationship
class Patient(SQLModel, table=True):
__tablename__ = "patient"
id: Optional[int] = Field(default=None, primary_key=True)
patient_id: str = Field(unique=True, index=True)
full_name: str = Field()
gender: str = Field()
age: Optional[int] = Field(default=None)
age_unit: Optional[str] = Field(default="year")
date_of_birth: Optional[datetime] = None
phone_key: str = Field()
phone_number: str = Field()
weight: Optional[float] = Field(default=None)
height: Optional[float] = Field(default=None)
province_id: Optional[int] = Field(default=None, foreign_key="province.id")
region_id: Optional[int] = Field(default=None, foreign_key="region.id")
fasting_time: Optional[int] = Field(default=None)
note: Optional[str] = Field(default=None)
email: Optional[str] = Field(default=None)
diagnosis: Optional[str] = Field(default=None)
symptoms: Optional[str] = Field(default=None)
therapy: Optional[str] = Field(default=None)
partner_id: Optional[int] = Field(default=None, foreign_key="partner.id")
doctor: Optional[str] = Field(default=None)
skin_colour: Optional[str] = Field(default=None)
agent_name: Optional[str] = Field(default=None)
is_outlab: bool = Field(default=False)
is_active: bool = Field(default=True)
created_by: Optional[int] = Field(default=None, foreign_key="user.id")
created_at: datetime = Field(default_factory=datetime.now)
edited_by: Optional[int] = Field(default=None, foreign_key="user.id")
edited_at: Optional[datetime] = None
deleted_by: Optional[int] = Field(default=None, foreign_key="user.id")
deleted_at: Optional[datetime] = None
deleted_reason: Optional[str] = Field(default=None)
# Relationships
visits: List["PatientVisit"] = Relationship(back_populates="patient", cascade_delete=True)
orders: List["Order"] = Relationship(back_populates="patient")
class PatientVisit(SQLModel, table=True):
__tablename__ = "patientvisit"
id: Optional[int] = Field(default=None, primary_key=True)
visit_id: str = Field(index=True)
patient_id: int = Field(foreign_key="patient.id")
visit_date: datetime = Field(default_factory=datetime.now)
is_active: bool = Field(default=True)
created_by: Optional[int] = Field(default=None, foreign_key="user.id")
created_at: datetime = Field(default_factory=datetime.now)
edited_by: Optional[int] = Field(default=None, foreign_key="user.id")
edited_at: Optional[datetime] = None
deleted_by: Optional[int] = Field(default=None, foreign_key="user.id")
deleted_at: Optional[datetime] = None
# Payment fields
received_amount: float = Field(default=0.0)
discount_amount: float = Field(default=0.0)
discount_percentage: float = Field(default=0.0)
discount_note: Optional[str] = Field(default=None)
tax_applied: bool = Field(default=True)
tax_amount: float = Field(default=0.0)
remaining_amount: float = Field(default=0.0)
# Call Centre fields
is_called: bool = Field(default=False)
is_whatsapp_sent: bool = Field(default=False)
is_printed: bool = Field(default=False)
# Relationships
patient: Optional["Patient"] = Relationship(back_populates="visits")
orders: List["Order"] = Relationship(back_populates="visit")
class Attachment(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
patient_id: int = Field(foreign_key="patient.id", index=True)
visit_id: Optional[int] = Field(default=None, foreign_key="patientvisit.id", index=True)
file_name: str
file_path: str
file_type: str
description: Optional[str] = None
uploaded_by: int = Field(foreign_key="user.id")
uploaded_at: datetime = Field(default_factory=datetime.now)