mtsd/backend/app/models/product_banner.py

"""商品轮播图模型"""
from datetime import datetime

from sqlalchemy import Column, String, DateTime, Integer, Text

from app.core.database import Base


class BasProductBanner(Base):
    """商品轮播图表"""
    __tablename__ = "bas_product_banner"

    id = Column(String(32), primary_key=True, comment="主键ID")
    product_id = Column(String(32), nullable=False, comment="商品ID")
    media_type = Column(String(20), nullable=False, default="image", comment="媒体类型：image-图片, video-视频")
    file_url = Column(String(500), nullable=False, comment="文件URL地址")
    thumbnail_url = Column(String(500), nullable=True, comment="缩略图URL")
    sort_order = Column(Integer, default=0, comment="排序")
    is_del = Column(Integer, default=0, comment="是否删除")
    create_at = Column(DateTime, default=datetime.now, comment="创建时间")
    create_by = Column(String(32), nullable=True, comment="创建人ID")
    create_name = Column(String(100), nullable=True, comment="创建人姓名")
    update_at = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment="修改时间")
    update_by = Column(String(32), nullable=True, comment="修改人ID")


class BasProductBannerHis(Base):
    """商品轮播图历史表"""
    __tablename__ = "bas_product_banner_his"

    id = Column(String(32), primary_key=True, nullable=False, comment="主键ID")
    product_id = Column(String(32), nullable=True, comment="商品ID")
    media_type = Column(String(20), default="image", comment="媒体类型")
    file_url = Column(String(500), nullable=True, comment="文件URL地址")
    thumbnail_url = Column(String(500), nullable=True, comment="缩略图URL")
    sort_order = Column(Integer, default=0, comment="排序")
    create_at = Column(DateTime, nullable=True, comment="创建时间")
    create_by = Column(String(32), nullable=True, comment="创建人ID")
    create_name = Column(String(100), nullable=True, comment="创建人姓名")
    update_at = Column(DateTime, nullable=True, comment="修改时间")
    update_by = Column(String(32), nullable=True, comment="修改人ID")
    his_create_at = Column(DateTime, default=datetime.now, comment="历史记录创建时间")