ticket.py 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. from sqlalchemy import Column, Integer, String, Text, DateTime, Enum, JSON
  2. from datetime import datetime
  3. from app.core.database import Base
  4. class VasTicket(Base):
  5. __tablename__ = "vas_ticket"
  6. __ddl__ = """
  7. CREATE TABLE IF NOT EXISTS `vas_ticket` (
  8. `id` INT NOT NULL AUTO_INCREMENT,
  9. `order_id` VARCHAR(128) NOT NULL,
  10. `user_id` VARCHAR(128) NOT NULL,
  11. `type` ENUM('refund','dispute','change_request') NOT NULL,
  12. `status` ENUM('pending','info_required','resolved','rejected') NOT NULL DEFAULT 'pending',
  13. `reason` TEXT NULL,
  14. `admin_comment` TEXT NULL,
  15. `extra_fields` JSON NULL,
  16. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  17. `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  18. PRIMARY KEY (`id`),
  19. KEY `idx_vas_ticket_order_id` (`order_id`),
  20. KEY `idx_vas_ticket_user_id` (`user_id`),
  21. KEY `idx_vas_ticket_status` (`status`)
  22. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='工单与售后仲裁表';
  23. """
  24. id = Column(Integer, primary_key=True, autoincrement=True)
  25. order_id = Column(String(128), nullable=False)
  26. user_id = Column(String(128), nullable=False)
  27. type = Column(Enum('refund','dispute','change_request'), nullable=False)
  28. status = Column(
  29. Enum('pending','info_required','resolved','rejected'),
  30. default='pending'
  31. )
  32. reason = Column(Text)
  33. admin_comment = Column(Text)
  34. extra_fields = Column(JSON)
  35. created_at = Column(DateTime, default=datetime.utcnow)
  36. updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)