NexLab_System / app /models /finance.py
alisaleem97's picture
Upload folder using huggingface_hub
6ea020b verified
Raw History Blame Contribute Delete
1.73 kB
# app/models/finance.py
# Payment, Expense, and ExpenseType models.
from typing import Optional
from datetime import datetime
from sqlmodel import SQLModel, Field, Relationship
class Payment(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
visit_id: int = Field(foreign_key="patientvisit.id", index=True)
patient_id: int = Field(foreign_key="patient.id", index=True)
amount: float
payment_method: str = Field(default="cash")
payment_date: datetime = Field(default_factory=datetime.now)
note: Optional[str] = None
recorded_by: int = Field(foreign_key="user.id")
is_refund: bool = Field(default=False)
class ExpenseType(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
type_name: str = Field(unique=True, index=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
class Expense(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
type_id: int = Field(foreign_key="expensetype.id", index=True)
expense_date: datetime = Field(default_factory=datetime.now)
amount: float = Field(default=0.0)
note: Optional[str] = None
file_path: Optional[str] = None
file_name: Optional[str] = None
created_by: int = Field(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
expense_type: "ExpenseType" = Relationship()