order.py 746 B

12345678910111213141516171819202122232425
  1. from sqlalchemy import Column, String, Integer, DateTime, JSON, Enum
  2. from datetime import datetime
  3. from app.core.database import Base
  4. class VasOrder(Base):
  5. __tablename__ = "vas_order"
  6. id = Column(String(128), primary_key=True)
  7. user_id = Column(String(128), nullable=False)
  8. product_id = Column(Integer, nullable=False)
  9. base_amount = Column(Integer, nullable=False)
  10. currency = Column(String(10), nullable=False)
  11. status = Column(
  12. Enum('pending','paid','completed','closed'),
  13. default='pending',
  14. nullable=False
  15. )
  16. user_inputs = Column(JSON)
  17. created_at = Column(DateTime, default=datetime.utcnow)
  18. updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)