payment_provider.py 1.3 KB

123456789101112131415161718192021222324252627282930313233
  1. from sqlalchemy import Column, Integer, String, Text, DateTime, Enum, JSON
  2. from datetime import datetime
  3. from app.core.database import Base
  4. class VasPaymentProvider(Base):
  5. __tablename__ = "vas_payment_provider"
  6. __ddl__ = """
  7. CREATE TABLE IF NOT EXISTS `vas_payment_provider` (
  8. `id` INT NOT NULL AUTO_INCREMENT,
  9. `name` VARCHAR(64) NOT NULL,
  10. `title` VARCHAR(100) NULL,
  11. `channel` VARCHAR(64) NOT NULL,
  12. `currency` VARCHAR(3) NOT NULL,
  13. `icon` TEXT NULL,
  14. `enabled` INT NOT NULL DEFAULT 1,
  15. `config` JSON NULL,
  16. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  17. `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  18. PRIMARY KEY (`id`)
  19. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='支付服务商配置表';
  20. """
  21. id = Column(Integer, primary_key=True, autoincrement=True)
  22. name = Column(String(64), nullable=False)
  23. title = Column(String(100))
  24. channel = Column(String(64), nullable=False)
  25. currency = Column(String(3), nullable=False)
  26. icon = Column(Text)
  27. enabled = Column(Integer, default=1)
  28. config = Column(JSON)
  29. created_at = Column(DateTime, default=datetime.utcnow)
  30. updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)