| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748 |
- 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)
|