payment.py 3.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495
  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. `fee_rate` DECIMAL(6,4) NOT NULL DEFAULT 0.0000,
  23. `fee_amount` INT NOT NULL DEFAULT 0,
  24. `exchange_rate` DECIMAL(18,8) NOT NULL,
  25. `qr_id` INT NULL,
  26. `payment_url` TEXT NULL,
  27. `expire_at` DATETIME NULL,
  28. `provider_payload` JSON NULL,
  29. `external_refund_no` VARCHAR(255) NULL,
  30. `refunded_at` DATETIME NULL,
  31. `refund_reason` VARCHAR(255) NULL,
  32. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  33. `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  34. PRIMARY KEY (`id`),
  35. KEY `idx_vas_payment_order_id` (`order_id`),
  36. KEY `idx_vas_payment_status` (`status`)
  37. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='支付交易记录表';
  38. """
  39. id = Column(Integer, primary_key=True, autoincrement=True)
  40. order_id = Column(String(128), nullable=False)
  41. provider = Column(String(64), nullable=False)
  42. channel = Column(String(50), nullable=False)
  43. # 支付意向ID (Stripe PaymentIntent ID)
  44. payment_intent_id = Column(String(255))
  45. # 外部交易号 (微信/支付宝的 transaction_id)
  46. external_trade_no = Column(String(255))
  47. # --- 修改点 1: 扩充状态枚举 ---
  48. status = Column(
  49. Enum(
  50. 'pending', # 待支付
  51. 'succeeded', # 支付成功
  52. 'failed', # 支付失败
  53. 'expired', # 支付超时
  54. 'late_paid', # 逾期支付(极少见)
  55. 'refunded', # 已全额退款
  56. ),
  57. default='pending',
  58. )
  59. base_amount = Column(Integer, nullable=False)
  60. adjustment_delta = Column(Integer, default=0)
  61. final_amount = Column(Integer, nullable=False)
  62. base_currency = Column(String(10), nullable=False)
  63. amount = Column(Integer, nullable=False)
  64. currency = Column(String(10), nullable=False)
  65. random_offset = Column(Integer, nullable=False)
  66. fee_rate = Column(DECIMAL(6, 4), nullable=False, default=0.0)
  67. fee_amount = Column(Integer, nullable=False, default=0)
  68. exchange_rate = Column(DECIMAL(18, 8), nullable=False)
  69. qr_id = Column(Integer)
  70. payment_url = Column(Text)
  71. expire_at = Column(DateTime)
  72. provider_payload = Column(JSON)
  73. # 外部退款单号 (Stripe Refund ID / 微信退款单号 / 支付宝退款单号)
  74. external_refund_no = Column(String(255))
  75. # 退款时间
  76. refunded_at = Column(DateTime)
  77. # 退款原因/备注
  78. refund_reason = Column(String(255))
  79. created_at = Column(DateTime, default=datetime.utcnow)
  80. updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)