# app/models/cost.py from datetime import datetime from sqlalchemy import Column, Integer, String, DateTime, Text, Enum from app.core.database import Base class VasCostRecord(Base): __tablename__ = "vas_cost_record" __ddl__ = """ CREATE TABLE IF NOT EXISTS `vas_cost_record` ( `id` INT NOT NULL AUTO_INCREMENT, `period_id` VARCHAR(32) NULL COMMENT '绑定的结算账期', `category` ENUM('vps', 'proxy_ip', 'captcha_api', 'sms_api', 'other') NOT NULL, `amount` INT NOT NULL COMMENT '金额 (分)', `currency` VARCHAR(8) NOT NULL DEFAULT 'CNY', `description` VARCHAR(255) NULL, `voucher_url` VARCHAR(512) NULL, `paid_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `created_by` VARCHAR(128) NOT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), INDEX `idx_vas_cost_period_id` (`period_id`), INDEX `idx_vas_cost_paid_at` (`paid_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='公共耗材支出表'; """ id = Column(Integer, primary_key=True, autoincrement=True) # 归属的结算账期ID (未结算前可为NULL,期末结算时绑定) period_id = Column(String(32), nullable=True, index=True) # 耗材类别 category = Column( Enum('vps', 'proxy_ip', 'captcha_api', 'sms_api', 'other', name='cost_category_enum'), nullable=False ) amount = Column(Integer, nullable=False) # 支出金额 (单位: 分) currency = Column(String(8), default="CNY", nullable=False) description = Column(String(255), nullable=True) voucher_url = Column(String(512), nullable=True) # 支付/充值截图凭证 paid_at = Column(DateTime, nullable=False, default=datetime.utcnow) # 实际支出时间 created_by = Column(String(128), nullable=False) # 录入人 created_at = Column(DateTime, default=datetime.utcnow)