from sqlalchemy import Column, Integer, String, Text, DateTime, Enum from datetime import datetime from app.core.database import Base class VasPaymentQR(Base): __tablename__ = "vas_payment_qr" __ddl__ = """ CREATE TABLE IF NOT EXISTS `vas_payment_qr` ( `id` INT NOT NULL AUTO_INCREMENT, `provider` ENUM('wechat','alipay') NOT NULL, `device` VARCHAR(50) NOT NULL, `qr_code` TEXT NOT NULL, `description` TEXT NOT NULL, `is_active` INT NOT NULL DEFAULT 1, `priority` INT NOT NULL DEFAULT 10, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='静态/固态聚合收款码轮转表'; """ id = Column(Integer, primary_key=True, autoincrement=True) provider = Column(Enum('wechat', 'alipay'), nullable=False) device = Column(String(50), nullable=False) qr_code = Column(Text, nullable=False) description = Column(Text, nullable=False) is_active = Column(Integer, default=1) priority = Column(Integer, default=10) created_at = Column(DateTime, default=datetime.utcnow)