"""
BUFF 选品请求单-选品日志表模型：记录第二步对每个饰品的判断结果与时间，供前端展示。
"""
from sqlalchemy import Column, BigInteger, Integer, String, DateTime, Numeric
from app.database import Base
from app.utils.timezone import beijing_now_naive


class BuffSelectionRequestLog(Base):
    """BUFF 选品请求单-选品日志表"""
    __tablename__ = "buff_selection_request_log"

    id = Column(BigInteger, primary_key=True, autoincrement=True, comment="主键ID")
    request_id = Column(BigInteger, nullable=False, index=True, comment="选品请求单ID")
    user_id = Column(Integer, nullable=False, index=True, comment="用户ID，按用户隔离")
    goods_id = Column(String(64), nullable=False, comment="BUFF饰品ID")
    goods_name = Column(String(256), nullable=True, comment="饰品名称，便于日志展示")
    sequence_no = Column(Integer, nullable=False, default=0, comment="判断序号：本次选品中第几个被判断")
    result = Column(String(20), nullable=False, comment="判断结果：selected-已入选, not_selected-未入选")
    message = Column(String(256), nullable=True, comment="简短说明，可为空")
    wear_range = Column(String(64), nullable=True, comment="磨损区间，如 0.00-0.02（selected 时记录）")
    price_cny = Column(Numeric(12, 2), nullable=True, comment="价格（人民币，selected 时记录）")
    price_usd = Column(Numeric(12, 2), nullable=True, comment="价格（美元，selected 时记录）")
    created_at = Column(DateTime, default=beijing_now_naive, comment="判断时间")