payment.py 3.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990
  1. from sqlalchemy import Column, Integer, String, Text, DateTime, Enum, JSON, DECIMAL
  2. from datetime import datetime
  3. from app.core.database import Base
  4. class VasPayment(Base):
  5. __tablename__ = "vas_payment"
  6. __ddl__ = """
  7. CREATE TABLE IF NOT EXISTS `vas_payment` (
  8. `id` INT NOT NULL AUTO_INCREMENT,
  9. `order_id` VARCHAR(128) NOT NULL,
  10. `provider` ENUM('stripe','wechat','alipay') NOT NULL,
  11. `channel` VARCHAR(50) NOT NULL,
  12. `payment_intent_id` VARCHAR(255) NULL,
  13. `external_trade_no` VARCHAR(255) NULL,
  14. `status` ENUM('pending','succeeded','failed','expired','late_paid','refunded') NOT NULL DEFAULT 'pending',
  15. `base_amount` INT NOT NULL,
  16. `adjustment_delta` INT NOT NULL DEFAULT 0,
  17. `final_amount` INT NOT NULL,
  18. `base_currency` VARCHAR(10) NOT NULL,
  19. `amount` INT NOT NULL,
  20. `currency` VARCHAR(10) NOT NULL,
  21. `random_offset` INT NOT NULL,
  22. `exchange_rate` DECIMAL(18,8) NOT NULL,
  23. `qr_id` INT NULL,
  24. `payment_url` TEXT NULL,
  25. `expire_at` DATETIME NULL,
  26. `provider_payload` JSON NULL,
  27. `external_refund_no` VARCHAR(255) NULL,
  28. `refunded_at` DATETIME NULL,
  29. `refund_reason` VARCHAR(255) NULL,
  30. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  31. `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  32. PRIMARY KEY (`id`),
  33. KEY `idx_vas_payment_order_id` (`order_id`),
  34. KEY `idx_vas_payment_status` (`status`)
  35. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='支付交易记录表';
  36. """
  37. id = Column(Integer, primary_key=True, autoincrement=True)
  38. order_id = Column(String(128), nullable=False)
  39. provider = Column(Enum('stripe', 'wechat', 'alipay'), nullable=False)
  40. channel = Column(String(50), nullable=False)
  41. # 支付意向ID (Stripe PaymentIntent ID)
  42. payment_intent_id = Column(String(255))
  43. # 外部交易号 (微信/支付宝的 transaction_id)
  44. external_trade_no = Column(String(255))
  45. # --- 修改点 1: 扩充状态枚举 ---
  46. status = Column(
  47. Enum(
  48. 'pending', # 待支付
  49. 'succeeded', # 支付成功
  50. 'failed', # 支付失败
  51. 'expired', # 支付超时
  52. 'late_paid', # 逾期支付(极少见)
  53. 'refunded', # 已全额退款
  54. ),
  55. default='pending',
  56. )
  57. base_amount = Column(Integer, nullable=False)
  58. adjustment_delta = Column(Integer, default=0)
  59. final_amount = Column(Integer, nullable=False)
  60. base_currency = Column(String(10), nullable=False)
  61. amount = Column(Integer, nullable=False)
  62. currency = Column(String(10), nullable=False)
  63. random_offset = Column(Integer, nullable=False)
  64. exchange_rate = Column(DECIMAL(18, 8), nullable=False)
  65. qr_id = Column(Integer)
  66. payment_url = Column(Text)
  67. expire_at = Column(DateTime)
  68. provider_payload = Column(JSON)
  69. # 外部退款单号 (Stripe Refund ID / 微信退款单号 / 支付宝退款单号)
  70. external_refund_no = Column(String(255))
  71. # 退款时间
  72. refunded_at = Column(DateTime)
  73. # 退款原因/备注
  74. refund_reason = Column(String(255))
  75. created_at = Column(DateTime, default=datetime.utcnow)
  76. updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)