| 1234567891011121314151617181920212223242526272829 |
- 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)
|