import uuid
from datetime import date, datetime, timezone
from sqlmodel import SQLModel, Field


class Score(SQLModel, table=True):
    __tablename__ = "scores"

    id: uuid.UUID = Field(default_factory=uuid.uuid4, primary_key=True)
    user_id: uuid.UUID = Field(foreign_key="users.id", index=True)
    date: date
    base_pts: int = 0
    bonus_pts: int = 0
    total_pts: int = 0
    streak_days: int = 0