product.py 2.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. from sqlalchemy import Column, String, Integer, Text, JSON, DateTime
  2. from datetime import datetime
  3. from app.core.database import Base
  4. class VasProduct(Base):
  5. __tablename__ = "vas_product"
  6. __ddl__ = """
  7. CREATE TABLE IF NOT EXISTS `vas_product` (
  8. `id` INT NOT NULL AUTO_INCREMENT,
  9. `country` VARCHAR(64) NOT NULL,
  10. `city` VARCHAR(64) NOT NULL,
  11. `visa_type` VARCHAR(64) NULL,
  12. `provider` VARCHAR(32) NOT NULL,
  13. `plugin_id` INT NULL COMMENT '绑定的处理插件ID',
  14. `plugin_name` VARCHAR(64) NULL COMMENT '绑定的处理插件英文标识',
  15. `title` VARCHAR(255) NOT NULL,
  16. `description` TEXT NULL,
  17. `extra_fields` JSON NULL,
  18. `price_amount` INT NOT NULL COMMENT '标价金额 (分)',
  19. `price_currency` VARCHAR(8) NOT NULL DEFAULT 'CNY',
  20. `min_floor_price` INT NOT NULL DEFAULT 0 COMMENT '内部最低协议底价(分)',
  21. `developer_id` VARCHAR(128) NULL COMMENT '对应底层脚本技术开发者ID (可由插件自动解析)',
  22. `schema_id` INT NULL,
  23. `enabled` INT NOT NULL DEFAULT 1,
  24. `recommend_score` INT NOT NULL DEFAULT 0,
  25. `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
  26. `updated_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  27. PRIMARY KEY (`id`),
  28. INDEX `idx_vas_product_provider` (`provider`),
  29. INDEX `idx_vas_product_plugin_id` (`plugin_id`),
  30. INDEX `idx_vas_product_plugin_name` (`plugin_name`),
  31. INDEX `idx_vas_product_country_city` (`country`, `city`)
  32. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='商品主表';
  33. """
  34. id = Column(Integer, primary_key=True, autoincrement=True)
  35. country = Column(String(64), nullable=False)
  36. city = Column(String(64), nullable=False)
  37. visa_type = Column(String(64))
  38. provider = Column(String(32), nullable=False)
  39. title = Column(String(255), nullable=False)
  40. description = Column(Text)
  41. extra_fields = Column(JSON)
  42. price_amount = Column(Integer, nullable=False)
  43. price_currency = Column(String(8), nullable=False)
  44. min_floor_price = Column(Integer, default=0, nullable=False) # 内部最低协议底价(分)
  45. plugin_id = Column(Integer, nullable=True, index=True, comment="绑定的处理插件ID")
  46. plugin_name = Column(String(64), nullable=True, index=True, comment="绑定的处理插件名称")
  47. developer_id = Column(String(128), nullable=True) # 对应底层脚本技术开发者ID (可由插件自动解析)
  48. schema_id = Column(Integer)
  49. enabled = Column(Integer, default=1)
  50. recommend_score = Column(Integer, default=0)
  51. created_at = Column(DateTime, default=datetime.utcnow)
  52. updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)