| 1234567891011121314151617181920 |
- """
- BUFF 选品配置表模型：用户检索条件 + 选品条件，支持多套配置与默认配置
- """
- from sqlalchemy import Column, BigInteger, Integer, String, DateTime, Boolean, Text
- from app.database import Base
- from app.utils.timezone import beijing_now_naive
- class BuffSelectionConfig(Base):
- """BUFF 选品配置表"""
- __tablename__ = "buff_selection_config"
- id = Column(BigInteger, primary_key=True, autoincrement=True, comment="主键ID")
- user_id = Column(Integer, nullable=False, comment="用户ID，关联 users.id")
- name = Column(String(64), nullable=False, comment="配置名称，同用户下未删除时唯一")
- config_json = Column(Text, nullable=False, comment="整份配置 JSON：检索条件+选品条件")
- is_default = Column(Boolean, nullable=False, default=False, comment="是否默认配置：同用户至多一个为 True")
- is_deleted = Column(Boolean, nullable=False, default=False, comment="软删：0-否，1-是")
- created_at = Column(DateTime, default=beijing_now_naive, comment="创建时间")
- updated_at = Column(DateTime, default=beijing_now_naive, onupdate=beijing_now_naive, comment="更新时间")
|
