sidequest_common.models.badges

Earned Hall of Heroes badges.

Badge definitions (id, name, description, icon, Discord role color) live in code (sidequest_common.schemas.badges.BADGES); this table only records who earned which one and when. Most badges are permanent once earned. top_helper is a moving monthly title: the service deletes/recreates this row for a new member instead of keeping history, so at most one top_helper row exists at a time. Rows are deleted with the member’s account (ondelete="CASCADE").

Classes

MemberBadge

One badge earned by one member.

Module Contents

class sidequest_common.models.badges.MemberBadge

Bases: advanced_alchemy.base.UUIDAuditBase

One badge earned by one member.

announced_at: sqlalchemy.orm.Mapped[datetime.datetime | None]

badge_id: sqlalchemy.orm.Mapped[str]

earned_at: sqlalchemy.orm.Mapped[datetime.datetime]

member_id: sqlalchemy.orm.Mapped[int]