| 12345678910111213141516171819 |
- """待补偿扣减记录模型"""
- 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())
|
