app/models/database/DBUser.py

from uuid import uuid4
from sqlalchemy import Column, DateTime, ForeignKey, JSON, delete,String, Boolean
from sqlalchemy.dialects.postgresql import UUID as PGUUID
from sqlalchemy.ext.asyncio import AsyncSession
from sqlalchemy.future import select
from app.models.database.base import Base
from datetime import datetime



# Database Model
class DBUser(Base):
    __tablename__ = "users"

    firebase_uid = Column(String, primary_key=True, index=True)
    email = Column(String, unique=True, index=True)
    display_name = Column(String, nullable=True)
    is_active = Column(Boolean, default=True)
    created_at = Column(DateTime, default=datetime.utcnow)
    last_login = Column(DateTime, nullable=True)
    provider = Column(String, default="email")