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