from sqlmodel import SQLModel, Field, Column, Text
from typing import Optional
from datetime import datetime

class User(SQLModel, table=True):
    __tablename__ = "users"

    id: Optional[int] = Field(default=None, primary_key=True)
    name: str = Field(nullable=False)
    email: str = Field(unique=True, index=True, nullable=False)
    mobile: Optional[str] = Field(default=None, unique=True, index=True, nullable=True)
    role: str = Field(default="customer", nullable=False)
    password_hash: str = Field(nullable=False)
    password_changed_at: Optional[datetime] = Field(default=None, nullable=True)
    is_email_verified: bool = Field(default=False, nullable=False)
    is_mobile_verified: bool = Field(default=False, nullable=False)
    failed_login_attempts: int = Field(default=0, nullable=False)
    lockout_until: Optional[datetime] = Field(default=None, nullable=True)
    country: Optional[str] = Field(default="United States", nullable=True)
    state: Optional[str] = Field(default=None, nullable=True)
    city: Optional[str] = Field(default=None, nullable=True)
    area_code: Optional[str] = Field(default=None, nullable=True)
    avatar: Optional[str] = Field(default=None, sa_column=Column(Text, nullable=True))
    created_at: datetime = Field(default_factory=datetime.utcnow, nullable=False)
    updated_at: Optional[datetime] = Field(default=None, nullable=True)
