payment_qr.py 1.1 KB

1234567891011121314151617181920212223242526272829
  1. from sqlalchemy import Column, Integer, String, Text, DateTime, Enum
  2. from datetime import datetime
  3. from app.core.database import Base
  4. class VasPaymentQR(Base):
  5. __tablename__ = "vas_payment_qr"
  6. __ddl__ = """
  7. CREATE TABLE IF NOT EXISTS `vas_payment_qr` (
  8. `id` INT NOT NULL AUTO_INCREMENT,
  9. `provider` ENUM('wechat','alipay') NOT NULL,
  10. `device` VARCHAR(50) NOT NULL,
  11. `qr_code` TEXT NOT NULL,
  12. `description` TEXT NOT NULL,
  13. `is_active` INT NOT NULL DEFAULT 1,
  14. `priority` INT NOT NULL DEFAULT 10,
  15. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  16. PRIMARY KEY (`id`)
  17. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='静态/固态聚合收款码轮转表';
  18. """
  19. id = Column(Integer, primary_key=True, autoincrement=True)
  20. provider = Column(Enum('wechat', 'alipay'), nullable=False)
  21. device = Column(String(50), nullable=False)
  22. qr_code = Column(Text, nullable=False)
  23. description = Column(Text, nullable=False)
  24. is_active = Column(Integer, default=1)
  25. priority = Column(Integer, default=10)
  26. created_at = Column(DateTime, default=datetime.utcnow)