from sqlalchemy import Column, BigInteger, Integer, String, Enum, DateTime, func
from app.core.database import Base


class VasPaymentConfirmation(Base):
    __tablename__ = "vas_payment_confirm"

    id = Column(BigInteger, primary_key=True, autoincrement=True)
    payment_id = Column(BigInteger, nullable=False)
    amount = Column(Integer, nullable=False)
    currency = Column(String(10), nullable=False)
    random_offset = Column(Integer, nullable=False)
    user_id = Column(String(128), nullable=False)
    status = Column(Enum("pending","confirmed","ignored"), nullable=False, default="pending")
    created_at = Column(DateTime, nullable=False, server_default=func.now())
    confirmed_at = Column(DateTime, nullable=True)
    admin_id = Column(String(128), nullable=True)
    admin_confirmed_at = Column(DateTime, nullable=True)