fault.py 1.8 KB

12345678910111213141516171819202122232425262728293031323334353637
  1. # app/models/fault.py
  2. from datetime import datetime
  3. from sqlalchemy import Column, Integer, String, DateTime, SmallInteger, Text
  4. from app.core.database import Base
  5. class VasFaultCompensation(Base):
  6. __tablename__ = "vas_fault_compensation"
  7. __ddl__ = """
  8. CREATE TABLE IF NOT EXISTS `vas_fault_compensation` (
  9. `id` INT NOT NULL AUTO_INCREMENT,
  10. `order_id` VARCHAR(128) NOT NULL,
  11. `liable_user_id` VARCHAR(128) NOT NULL COMMENT '责任人',
  12. `penalty_amount` INT NOT NULL COMMENT '扣罚金额 (分)',
  13. `reason` VARCHAR(255) NOT NULL,
  14. `notes` TEXT NULL,
  15. `period_id` VARCHAR(32) NULL COMMENT '冲销账期',
  16. `deducted_status` SMALLINT NOT NULL DEFAULT 0 COMMENT '0:待扣除, 1:已从提成中扣除',
  17. `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
  18. PRIMARY KEY (`id`),
  19. INDEX `idx_vas_fault_order_id` (`order_id`),
  20. INDEX `idx_vas_fault_liable_user` (`liable_user_id`),
  21. INDEX `idx_vas_fault_period_id` (`period_id`)
  22. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='过失录错赔偿冲销表';
  23. """
  24. id = Column(Integer, primary_key=True, autoincrement=True)
  25. order_id = Column(String(128), nullable=False, index=True)
  26. liable_user_id = Column(String(128), nullable=False, index=True) # 录错/过失责任人
  27. penalty_amount = Column(Integer, nullable=False) # 应由个人全额承担的赔偿金额 (分)
  28. reason = Column(String(255), nullable=False) # 过错原因(如: 护照号录错导致废单)
  29. notes = Column(Text, nullable=True)
  30. period_id = Column(String(32), nullable=True, index=True) # 在哪个结算账期冲销
  31. deducted_status = Column(SmallInteger, default=0, nullable=False) # 0:待扣除, 1:已从提成中扣除
  32. created_at = Column(DateTime, default=datetime.utcnow)