from sqlalchemy import Column, String, Integer, Text, JSON, DateTime from datetime import datetime from app.core.database import Base class VasProduct(Base): __tablename__ = "vas_product" __ddl__ = """ CREATE TABLE IF NOT EXISTS `vas_product` ( `id` INT NOT NULL AUTO_INCREMENT, `country` VARCHAR(64) NOT NULL, `city` VARCHAR(64) NOT NULL, `visa_type` VARCHAR(64) NULL, `provider` VARCHAR(32) NOT NULL, `plugin_id` INT NULL COMMENT '绑定的处理插件ID', `plugin_name` VARCHAR(64) NULL COMMENT '绑定的处理插件英文标识', `title` VARCHAR(255) NOT NULL, `description` TEXT NULL, `extra_fields` JSON NULL, `price_amount` INT NOT NULL COMMENT '标价金额 (分)', `price_currency` VARCHAR(8) NOT NULL DEFAULT 'CNY', `min_floor_price` INT NOT NULL DEFAULT 0 COMMENT '内部最低协议底价(分)', `developer_id` VARCHAR(128) NULL COMMENT '对应底层脚本技术开发者ID (可由插件自动解析)', `schema_id` INT NULL, `enabled` INT NOT NULL DEFAULT 1, `recommend_score` INT NOT NULL DEFAULT 0, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), INDEX `idx_vas_product_provider` (`provider`), INDEX `idx_vas_product_plugin_id` (`plugin_id`), INDEX `idx_vas_product_plugin_name` (`plugin_name`), INDEX `idx_vas_product_country_city` (`country`, `city`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='商品主表'; """ id = Column(Integer, primary_key=True, autoincrement=True) country = Column(String(64), nullable=False) city = Column(String(64), nullable=False) visa_type = Column(String(64)) provider = Column(String(32), nullable=False) title = Column(String(255), nullable=False) description = Column(Text) extra_fields = Column(JSON) price_amount = Column(Integer, nullable=False) price_currency = Column(String(8), nullable=False) min_floor_price = Column(Integer, default=0, nullable=False) # 内部最低协议底价(分) plugin_id = Column(Integer, nullable=True, index=True, comment="绑定的处理插件ID") plugin_name = Column(String(64), nullable=True, index=True, comment="绑定的处理插件名称") developer_id = Column(String(128), nullable=True) # 对应底层脚本技术开发者ID (可由插件自动解析) schema_id = Column(Integer) enabled = Column(Integer, default=1) recommend_score = Column(Integer, default=0) created_at = Column(DateTime, default=datetime.utcnow) updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)