webapp/app/models/ticket_message.py

from sqlalchemy import (
    Column,
    Integer,
    ForeignKey,
    Enum,
    Text,
    DateTime,
    JSON,
    Index,
    String
)
from datetime import datetime
from app.core.database import Base


class VasTicketMessage(Base):
    __tablename__ = "vas_ticket_message"

    id = Column(Integer, primary_key=True, autoincrement=True)

    ticket_id = Column(Integer, nullable=False)

    sender_type = Column(
        Enum("user", "admin", "system", name="ticket_sender_enum"),
        nullable=False
    )

    sender_id = Column(String(128), nullable=True)

    content = Column(Text, nullable=False)

    attachments = Column(JSON)  # 图片 / 文件

    created_at = Column(DateTime, default=datetime.utcnow)