"""Tracking SQLAlchemy model."""
from sqlalchemy import Column, Integer, Date, Boolean, Text, ForeignKey
from sqlalchemy.orm import relationship
from backend.database import Base


class Tracking(Base):
    """Tracking model for recording challenge progress."""
    __tablename__ = "tracking"

    id = Column(Integer, primary_key=True, index=True)
    challenge_id = Column(Integer, ForeignKey("challenges.id"))
    date = Column(Date)
    reps = Column(Integer, default=0)
    completed = Column(Boolean, default=False)
    notes = Column(Text, nullable=True)

    challenge = relationship("Challenge", back_populates="trackings")