cost.py 1.8 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. # app/models/cost.py
  2. from datetime import datetime
  3. from sqlalchemy import Column, Integer, String, DateTime, Text, Enum
  4. from app.core.database import Base
  5. class VasCostRecord(Base):
  6. __tablename__ = "vas_cost_record"
  7. __ddl__ = """
  8. CREATE TABLE IF NOT EXISTS `vas_cost_record` (
  9. `id` INT NOT NULL AUTO_INCREMENT,
  10. `period_id` VARCHAR(32) NULL COMMENT '绑定的结算账期',
  11. `category` ENUM('vps', 'proxy_ip', 'captcha_api', 'sms_api', 'other') NOT NULL,
  12. `amount` INT NOT NULL COMMENT '金额 (分)',
  13. `currency` VARCHAR(8) NOT NULL DEFAULT 'CNY',
  14. `description` VARCHAR(255) NULL,
  15. `voucher_url` VARCHAR(512) NULL,
  16. `paid_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  17. `created_by` VARCHAR(128) NOT NULL,
  18. `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
  19. PRIMARY KEY (`id`),
  20. INDEX `idx_vas_cost_period_id` (`period_id`),
  21. INDEX `idx_vas_cost_paid_at` (`paid_at`)
  22. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='公共耗材支出表';
  23. """
  24. id = Column(Integer, primary_key=True, autoincrement=True)
  25. # 归属的结算账期ID (未结算前可为NULL,期末结算时绑定)
  26. period_id = Column(String(32), nullable=True, index=True)
  27. # 耗材类别
  28. category = Column(
  29. Enum('vps', 'proxy_ip', 'captcha_api', 'sms_api', 'other', name='cost_category_enum'),
  30. nullable=False
  31. )
  32. amount = Column(Integer, nullable=False) # 支出金额 (单位: 分)
  33. currency = Column(String(8), default="CNY", nullable=False)
  34. description = Column(String(255), nullable=True)
  35. voucher_url = Column(String(512), nullable=True) # 支付/充值截图凭证
  36. paid_at = Column(DateTime, nullable=False, default=datetime.utcnow) # 实际支出时间
  37. created_by = Column(String(128), nullable=False) # 录入人
  38. created_at = Column(DateTime, default=datetime.utcnow)