mtsd/backend/app/models/product_review.py

"""售后评价模型"""
from datetime import datetime

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

from app.core.database import Base


class BizProductReview(Base):
    """商品售后评价表"""
    __tablename__ = "biz_product_review"

    id = Column(String(32), primary_key=True, comment="主键ID")
    product_id = Column(String(32), nullable=False, comment="商品ID")
    order_id = Column(String(32), nullable=True, comment="订单ID")
    order_item_id = Column(String(32), nullable=True, comment="订单项ID")
    user_id = Column(String(32), nullable=False, comment="评价用户ID")
    user_name = Column(String(100), nullable=True, comment="评价用户姓名")
    rating = Column(Integer, nullable=False, default=5, comment="评分（1-5星）")
    rating_tags = Column(String(500), nullable=True, comment="评价标签，多个逗号分隔")
    content = Column(Text, nullable=True, comment="评价内容")
    is_anonymous = Column(Integer, default=0, comment="是否匿名：0-否, 1-是")
    reply_content = Column(Text, nullable=True, comment="商家回复内容")
    reply_time = Column(DateTime, nullable=True, comment="商家回复时间")
    reply_by = Column(String(32), nullable=True, comment="回复人ID")
    reply_by_name = Column(String(100), nullable=True, comment="回复人姓名")
    like_count = Column(Integer, default=0, comment="点赞数")
    is_top = Column(Integer, default=0, comment="是否置顶：0-否, 1-是")
    status = Column(String(20), default="pending", comment="状态：pending-待审核, approved-已通过, rejected-已拒绝")
    reject_reason = Column(String(500), nullable=True, comment="拒绝原因")
    is_del = Column(Integer, default=0, comment="是否删除：0-否, 1-是")
    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 BizProductReviewHis(Base):
    """商品售后评价历史表"""
    __tablename__ = "biz_product_review_his"

    id = Column(String(32), primary_key=True, nullable=False, comment="主键ID")
    product_id = Column(String(32), nullable=True, comment="商品ID")
    order_id = Column(String(32), nullable=True, comment="订单ID")
    order_item_id = Column(String(32), nullable=True, comment="订单项ID")
    user_id = Column(String(32), nullable=True, comment="评价用户ID")
    user_name = Column(String(100), nullable=True, comment="评价用户姓名")
    rating = Column(Integer, default=5, comment="评分")
    rating_tags = Column(String(500), nullable=True, comment="评价标签")
    content = Column(Text, nullable=True, comment="评价内容")
    is_anonymous = Column(Integer, default=0, comment="是否匿名")
    reply_content = Column(Text, nullable=True, comment="商家回复内容")
    reply_time = Column(DateTime, nullable=True, comment="商家回复时间")
    reply_by = Column(String(32), nullable=True, comment="回复人ID")
    reply_by_name = Column(String(100), nullable=True, comment="回复人姓名")
    like_count = Column(Integer, default=0, comment="点赞数")
    is_top = Column(Integer, default=0, comment="是否置顶")
    status = Column(String(20), default="pending", comment="状态")
    reject_reason = Column(String(500), nullable=True, 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="历史记录创建时间")