"""待补偿扣减记录模型"""
from sqlalchemy import Column, Integer, String, Numeric, Text, DateTime, func
from app.models import Base


class PendingDeduction(Base):
    """待补偿扣减记录：扣减失败时写入，后台任务重试"""
    __tablename__ = "pending_deductions"
    __table_args__ = {"schema": "domain_monitor"}

    id = Column(Integer, primary_key=True, autoincrement=True)
    target_type = Column(String(20), nullable=False)       # 'tenant' / 'sa'
    target_id = Column(Integer, nullable=False)            # tenant_id 或 panel_sa_id
    amount = Column(Numeric(20, 4), nullable=False)
    biz_order_no = Column(String(100), nullable=False)
    retry_count = Column(Integer, default=0, server_default="0")
    last_error = Column(Text)
    created_at = Column(DateTime(timezone=True), server_default=func.now())
    updated_at = Column(DateTime(timezone=True), server_default=func.now(), onupdate=func.now())