Class User

app/models.py:59–92

class User(Base):
    __tablename__: str = "user"

    id: Mapped[int] = mapped_column(primary_key=True)
    email: Mapped[str] = mapped_column(
        String(320), index=True, unique=True, nullable=False
    )
    username: Mapped[str] = mapped_column(
        String(50), index=True, unique=True, nullable=False
    )
    name: Mapped[str | None] = mapped_column(String(256), index=True, nullable=True)
    email_verified: Mapped[bool] = mapped_column(Boolean, default=False)
    has_avatar: Mapped[bool] = mapped_column(Boolean, nullable=False, default=False)
    status: Mapped[str] = mapped_column(
        SQLAEnum("active", "deleted", name="team_status"),
        nullable=False,
        default="active",
    )
    created_at: Mapped[datetime] = mapped_column(
        index=True, nullable=False, default=utc_now
    )
    updated_at: Mapped[datetime] = mapped_column(
        index=True, nullable=False, default=utc_now, onupdate=utc_now
    )
    tokens_invalid_before: Mapped[datetime | None] = mapped_column(nullable=True)
    default_team_id: Mapped[str] = mapped_column(ForeignKey("team.id"), nullable=True)

    # Relationships
    default_team: Mapped["Team"] = relationship(foreign_keys=[default_team_id])
    identities: Mapped[list["UserIdentity"]] = relationship(back_populates="user")

    @override
    def __repr__(self):
        return f"<User {self.email}>"


class UserIdentity(Base):