from datetime import datetime, timezone from sqlalchemy import Column, BigInteger, String, Date, DateTime, ForeignKey from app.core.database import Base class User(Base): __tablename__ = "users" id = Column(BigInteger, primary_key=True, autoincrement=True) account_id = Column(BigInteger, ForeignKey("accounts.id"), nullable=False) name = Column(String(100), nullable=False) lastname = Column(String(100), nullable=False) card_id = Column(String(50), unique=True) birthdate = Column(Date) sex = Column(String(1)) phone_number = Column(String(20)) secondary_phone_number = Column(String(20)) email = Column(String(150), unique=True) password_hash = Column(String(255)) parent_id = Column(BigInteger, ForeignKey("users.id"), nullable=True) role = Column(String(20), nullable=False, default="student") # admin | teacher | representative | student is_active = Column(String(1), default="1") must_change_password = Column(String(1), default="0") password_reset_token = Column(String(255), nullable=True) password_reset_expires = Column(DateTime(timezone=True), nullable=True)