from sqlalchemy import Column, Integer, String, Float, Text, ForeignKey

from app.models.base import Base


class Checkin(Base):
    __tablename__ = "checkins"

    id = Column(Integer, primary_key=True)
    user_id = Column(Integer, ForeignKey("users.id"), nullable=False)
    date = Column(String(20), nullable=False)
    feeling = Column(String(20))
    weight_lb = Column(Float)
    calories = Column(Integer)
    steps = Column(Integer)
    sleep_hours = Column(Float)
    notes = Column(Text)