webapp/app/models/user.py

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


class VasUser(Base):
    __tablename__ = "vas_user"

    id = Column(String(128), primary_key=True)
    role = Column(String(32))
    email = Column(String(128))
    phone = Column(String(32))
    nickname = Column(String(64))
    avatar_url = Column(String(255))
    preferred_language = Column(String(8))
    timezone = Column(String(32))

    register_ip = Column(String(64))
    last_login_ip = Column(String(64))

    password_hash = Column(String(255))
    email_verified = Column(Integer, default=0)

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