webapp/app/models/email_verification.py

from sqlalchemy import Column, String, DateTime, Integer
from datetime import datetime
from app.core.database import Base


class VasEmailVerification(Base):
    __tablename__ = "vas_email_verification"

    id = Column(Integer, primary_key=True, autoincrement=True)
    user_id = Column(String(64), nullable=False)
    email = Column(String(255), nullable=False)
    token = Column(String(128), nullable=False)
    used = Column(Integer, default=0)
    expire_at = Column(DateTime, nullable=False)

    created_at = Column(DateTime, default=datetime.utcnow)