from sqlalchemy import Column, Integer, String, Text, DateTime, Enum, JSON, DECIMAL from datetime import datetime from app.core.database import Base class VasPayment(Base): __tablename__ = "vas_payment" __ddl__ = """ CREATE TABLE IF NOT EXISTS `vas_payment` ( `id` INT NOT NULL AUTO_INCREMENT, `order_id` VARCHAR(128) NOT NULL, `provider` ENUM('stripe','wechat','alipay') NOT NULL, `channel` VARCHAR(50) NOT NULL, `payment_intent_id` VARCHAR(255) NULL, `external_trade_no` VARCHAR(255) NULL, `status` ENUM('pending','succeeded','failed','expired','late_paid','refunded') NOT NULL DEFAULT 'pending', `base_amount` INT NOT NULL, `adjustment_delta` INT NOT NULL DEFAULT 0, `final_amount` INT NOT NULL, `base_currency` VARCHAR(10) NOT NULL, `amount` INT NOT NULL, `currency` VARCHAR(10) NOT NULL, `random_offset` INT NOT NULL, `fee_rate` DECIMAL(6,4) NOT NULL DEFAULT 0.0000, `fee_amount` INT NOT NULL DEFAULT 0, `exchange_rate` DECIMAL(18,8) NOT NULL, `qr_id` INT NULL, `payment_url` TEXT NULL, `expire_at` DATETIME NULL, `provider_payload` JSON NULL, `external_refund_no` VARCHAR(255) NULL, `refunded_at` DATETIME NULL, `refund_reason` VARCHAR(255) NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_vas_payment_order_id` (`order_id`), KEY `idx_vas_payment_status` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='支付交易记录表'; """ id = Column(Integer, primary_key=True, autoincrement=True) order_id = Column(String(128), nullable=False) provider = Column(String(64), nullable=False) channel = Column(String(50), nullable=False) # 支付意向ID (Stripe PaymentIntent ID) payment_intent_id = Column(String(255)) # 外部交易号 (微信/支付宝的 transaction_id) external_trade_no = Column(String(255)) # --- 修改点 1: 扩充状态枚举 --- status = Column( Enum( 'pending', # 待支付 'succeeded', # 支付成功 'failed', # 支付失败 'expired', # 支付超时 'late_paid', # 逾期支付(极少见) 'refunded', # 已全额退款 ), default='pending', ) base_amount = Column(Integer, nullable=False) adjustment_delta = Column(Integer, default=0) final_amount = Column(Integer, nullable=False) base_currency = Column(String(10), nullable=False) amount = Column(Integer, nullable=False) currency = Column(String(10), nullable=False) random_offset = Column(Integer, nullable=False) fee_rate = Column(DECIMAL(6, 4), nullable=False, default=0.0) fee_amount = Column(Integer, nullable=False, default=0) exchange_rate = Column(DECIMAL(18, 8), nullable=False) qr_id = Column(Integer) payment_url = Column(Text) expire_at = Column(DateTime) provider_payload = Column(JSON) # 外部退款单号 (Stripe Refund ID / 微信退款单号 / 支付宝退款单号) external_refund_no = Column(String(255)) # 退款时间 refunded_at = Column(DateTime) # 退款原因/备注 refund_reason = Column(String(255)) created_at = Column(DateTime, default=datetime.utcnow) updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)