from sqlalchemy import Column, Integer, String, DateTime, JSON from datetime import datetime from app.core.database import Base class VasProductRouting(Base): __tablename__ = "vas_product_routing" __ddl__ = """ CREATE TABLE IF NOT EXISTS `vas_product_routing` ( `id` INT NOT NULL AUTO_INCREMENT, `product_id` INT NOT NULL, `routing_key` VARCHAR(255) NOT NULL, `script_version` VARCHAR(50) NOT NULL, `is_active` INT NOT NULL DEFAULT 1, `priority` INT NOT NULL DEFAULT 10, `config` JSON NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_vas_routing_product_id` (`product_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='产品路由分流配置表'; """ id = Column(Integer, primary_key=True, autoincrement=True) product_id = Column(Integer, nullable=False) routing_key = Column(String(255), nullable=False) script_version = Column(String(50), nullable=False) is_active = Column(Integer, default=1) priority = Column(Integer, default=10) config = Column(JSON) created_at = Column(DateTime, default=datetime.utcnow) updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)