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