from sqlalchemy import Float, String from sqlalchemy.orm import Mapped, mapped_column from app.db import Base class PooRecord(Base): __tablename__ = "poo_records" timestamp: Mapped[str] = mapped_column(String, primary_key=True) status: Mapped[str] = mapped_column(String, nullable=False) latitude: Mapped[float] = mapped_column(Float, nullable=False) longitude: Mapped[float] = mapped_column(Float, nullable=False)