ticket.py 794 B

123456789101112131415161718192021222324
  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. id = Column(Integer, primary_key=True, autoincrement=True)
  7. order_id = Column(String(128), nullable=False)
  8. user_id = Column(String(128), nullable=False)
  9. type = Column(Enum('refund','dispute','change_request'), nullable=False)
  10. status = Column(
  11. Enum('pending','info_required','resolved','rejected'),
  12. default='pending'
  13. )
  14. reason = Column(Text)
  15. admin_comment = Column(Text)
  16. extra_fields = Column(JSON)
  17. created_at = Column(DateTime, default=datetime.utcnow)
  18. updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)