"""Odds model"""
from sqlalchemy import Column, Integer, ForeignKey, Float, DateTime, String
from datetime import datetime
from app.core.db.database import Base


class Odds(Base):
    """Betting odds (1X2 history)

    This project currently stores odds in the `odds_1x2` table.
    """
    __tablename__ = "odds_1x2"
    
    id = Column(Integer, primary_key=True, index=True)
    match_id = Column(Integer, ForeignKey("matches.id"), nullable=False, index=True)
    bookmaker = Column(String)
    
    home_win = Column("odd_home", Float)
    draw = Column("odd_draw", Float)
    away_win = Column("odd_away", Float)
    
    # Additional markets (nullable; may be absent in source)
    over_2_5 = Column(Float)
    under_2_5 = Column(Float)
    both_score_yes = Column(Float)
    both_score_no = Column(Float)
    
    captured_at = Column(DateTime, default=datetime.utcnow, index=True)