app/model/transaction.py

from datetime import datetime
from sqlalchemy import ForeignKey
from sqlalchemy.orm import relationship, Mapped, mapped_column

from app.model.base import BaseModel
from app.engine.postgresdb import Base


class Transaction(Base, BaseModel):
    __tablename__ = "transactions"
    transaction_date: Mapped[datetime]
    category: Mapped[str]
    name_description: Mapped[str]
    amount: Mapped[float]
    type: Mapped[str]

    user_id = mapped_column(ForeignKey("users.id"))
    user = relationship("User", back_populates="transactions")