payment_confirmation.py 841 B

123456789101112131415161718
  1. from sqlalchemy import Column, BigInteger, Integer, String, Enum, DateTime, func
  2. from app.core.database import Base
  3. class VasPaymentConfirmation(Base):
  4. __tablename__ = "vas_payment_confirm"
  5. id = Column(BigInteger, primary_key=True, autoincrement=True)
  6. payment_id = Column(BigInteger, nullable=False)
  7. amount = Column(Integer, nullable=False)
  8. currency = Column(String(10), nullable=False)
  9. random_offset = Column(Integer, nullable=False)
  10. user_id = Column(String(128), nullable=False)
  11. status = Column(Enum("pending","confirmed","ignored"), nullable=False, default="pending")
  12. created_at = Column(DateTime, nullable=False, server_default=func.now())
  13. confirmed_at = Column(DateTime, nullable=True)
  14. admin_id = Column(String(128), nullable=True)
  15. admin_confirmed_at = Column(DateTime, nullable=True)