from datetime import datetime
from sqlalchemy import (INTEGER,TIMESTAMP,VARCHAR, ForeignKey)
from sqlalchemy.orm import (Mapped,mapped_column)
from app.models.main import Base


class TblUserOTP(Base):
    __tablename__ = "tbl_user_otp"

    otp_id: Mapped[int] = mapped_column(INTEGER, primary_key=True, autoincrement=True)
    usr_id: Mapped[int] = mapped_column(INTEGER, ForeignKey("tbl_users.usr_id"), nullable=False)
    otp: Mapped[str] = mapped_column(VARCHAR(6), nullable=False)
    expiry: Mapped[datetime] = mapped_column(TIMESTAMP, nullable=False)