| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364 |
- # app/models/payment_event.py
- from sqlalchemy import (
- Column, Integer, String, Text, DateTime, JSON, BigInteger
- )
- from datetime import datetime
- from app.core.database import Base
- class VasPaymentEvent(Base):
- __tablename__ = "vas_payment_event"
- __ddl__ = """
- CREATE TABLE IF NOT EXISTS `vas_payment_event` (
- `id` BIGINT NOT NULL AUTO_INCREMENT,
- `provider` VARCHAR(32) NOT NULL,
- `event_type` VARCHAR(64) NULL,
- `event_id` VARCHAR(128) NULL,
- `title` TEXT NULL,
- `content` TEXT NULL,
- `raw_payload` JSON NULL,
- `parsed_amount` BIGINT NULL,
- `parsed_currency` VARCHAR(8) NULL,
- `parsed_device` VARCHAR(64) NULL,
- `matched_payment_id` BIGINT NULL,
- `matched_order_id` VARCHAR(128) NULL,
- `status` VARCHAR(32) NOT NULL DEFAULT 'received',
- `error_message` TEXT NULL,
- `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`),
- UNIQUE KEY `uq_vas_pay_event_id` (`event_id`),
- KEY `idx_vas_pay_event_matched_order` (`matched_order_id`),
- KEY `idx_vas_pay_event_status` (`status`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='网关支付原始异步事件通知记录表';
- """
- id = Column(BigInteger, primary_key=True, autoincrement=True)
- # ---- 来源 ----
- provider = Column(String(32), nullable=False) # wechat | alipay | stripe
- event_type = Column(String(64)) # payment_received | checkout.session.completed
- event_id = Column(String(128), unique=True) # Stripe event.id / 自生成 hash
- # ---- 原始内容 ----
- title = Column(Text)
- content = Column(Text)
- raw_payload = Column(JSON)
- # ---- 解析结果 ----
- parsed_amount = Column(BigInteger) # 最小货币单位
- parsed_currency = Column(String(8))
- parsed_device = Column(String(64))
- # ---- 业务关联 ----
- matched_payment_id = Column(BigInteger)
- matched_order_id = Column(String(128))
- # ---- 状态 ----
- status = Column(
- String(32), # received | matched | applied | duplicate | failed
- nullable=False,
- default="received"
- )
- error_message = Column(Text)
- created_at = Column(DateTime, default=datetime.utcnow)
|