| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495 |
- 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)
|