payment_event.py 2.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  1. # app/models/payment_event.py
  2. from sqlalchemy import (
  3. Column, Integer, String, Text, DateTime, JSON, BigInteger
  4. )
  5. from datetime import datetime
  6. from app.core.database import Base
  7. class VasPaymentEvent(Base):
  8. __tablename__ = "vas_payment_event"
  9. __ddl__ = """
  10. CREATE TABLE IF NOT EXISTS `vas_payment_event` (
  11. `id` BIGINT NOT NULL AUTO_INCREMENT,
  12. `provider` VARCHAR(32) NOT NULL,
  13. `event_type` VARCHAR(64) NULL,
  14. `event_id` VARCHAR(128) NULL,
  15. `title` TEXT NULL,
  16. `content` TEXT NULL,
  17. `raw_payload` JSON NULL,
  18. `parsed_amount` BIGINT NULL,
  19. `parsed_currency` VARCHAR(8) NULL,
  20. `parsed_device` VARCHAR(64) NULL,
  21. `matched_payment_id` BIGINT NULL,
  22. `matched_order_id` VARCHAR(128) NULL,
  23. `status` VARCHAR(32) NOT NULL DEFAULT 'received',
  24. `error_message` TEXT NULL,
  25. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  26. PRIMARY KEY (`id`),
  27. UNIQUE KEY `uq_vas_pay_event_id` (`event_id`),
  28. KEY `idx_vas_pay_event_matched_order` (`matched_order_id`),
  29. KEY `idx_vas_pay_event_status` (`status`)
  30. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='网关支付原始异步事件通知记录表';
  31. """
  32. id = Column(BigInteger, primary_key=True, autoincrement=True)
  33. # ---- 来源 ----
  34. provider = Column(String(32), nullable=False) # wechat | alipay | stripe
  35. event_type = Column(String(64)) # payment_received | checkout.session.completed
  36. event_id = Column(String(128), unique=True) # Stripe event.id / 自生成 hash
  37. # ---- 原始内容 ----
  38. title = Column(Text)
  39. content = Column(Text)
  40. raw_payload = Column(JSON)
  41. # ---- 解析结果 ----
  42. parsed_amount = Column(BigInteger) # 最小货币单位
  43. parsed_currency = Column(String(8))
  44. parsed_device = Column(String(64))
  45. # ---- 业务关联 ----
  46. matched_payment_id = Column(BigInteger)
  47. matched_order_id = Column(String(128))
  48. # ---- 状态 ----
  49. status = Column(
  50. String(32), # received | matched | applied | duplicate | failed
  51. nullable=False,
  52. default="received"
  53. )
  54. error_message = Column(Text)
  55. created_at = Column(DateTime, default=datetime.utcnow)