from sqlalchemy import Column, Integer, String, Text, DateTime, Enum, JSON from datetime import datetime from app.core.database import Base class VasTicket(Base): __tablename__ = "vas_ticket" __ddl__ = """ CREATE TABLE IF NOT EXISTS `vas_ticket` ( `id` INT NOT NULL AUTO_INCREMENT, `order_id` VARCHAR(128) NOT NULL, `user_id` VARCHAR(128) NOT NULL, `type` ENUM('refund','dispute','change_request') NOT NULL, `status` ENUM('pending','info_required','resolved','rejected') NOT NULL DEFAULT 'pending', `reason` TEXT NULL, `admin_comment` TEXT NULL, `extra_fields` JSON NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_vas_ticket_order_id` (`order_id`), KEY `idx_vas_ticket_user_id` (`user_id`), KEY `idx_vas_ticket_status` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='工单与售后仲裁表'; """ id = Column(Integer, primary_key=True, autoincrement=True) order_id = Column(String(128), nullable=False) user_id = Column(String(128), nullable=False) type = Column(Enum('refund','dispute','change_request'), nullable=False) status = Column( Enum('pending','info_required','resolved','rejected'), default='pending' ) reason = Column(Text) admin_comment = Column(Text) extra_fields = Column(JSON) created_at = Column(DateTime, default=datetime.utcnow) updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)