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" __ddl__ = """ CREATE TABLE IF NOT EXISTS `vas_ticket_message` ( `id` INT NOT NULL AUTO_INCREMENT, `ticket_id` INT NOT NULL, `sender_type` ENUM('user','admin','system') NOT NULL, `sender_id` VARCHAR(128) NULL, `content` TEXT NOT NULL, `attachments` JSON NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_vas_ticket_msg_ticket_id` (`ticket_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='工单沟通对话消息表'; """ 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)