src/entity/fraud_details.py

from sqlalchemy import String, Float, Boolean, DateTime, ForeignKey
from sqlalchemy.orm import relationship, mapped_column, Mapped

from . import Base

class FraudDetails(Base):
    __tablename__ = "fraud_details"

    # Transaction table columns
    id: Mapped[int] = mapped_column(primary_key=True, autoincrement=True)
    fraud_score: Mapped[float] = mapped_column(Float, nullable=True)
    model_version: Mapped[str] = mapped_column(String(50), nullable=True)
    notification_sent: Mapped[bool] = mapped_column(Boolean, nullable=False, default=False)
    notification_recipients: Mapped[str] = mapped_column(String(255), nullable=True)
    notification_datetime: Mapped[DateTime] = mapped_column(DateTime, nullable=True)

    fk_transaction_id: Mapped[int] = mapped_column(ForeignKey("transactions.id"))
    transaction: Mapped["Transaction"] = relationship("Transaction", back_populates="fraud_details")