| 12345678910111213141516171819202122232425262728293031323334353637383940414243 |
- # 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)
|