In the Khoros Community Standard XML Export, the user <--> badge mapping lives in the *Badges_Users* table (underlying DB table: tblia_badges_users).
Pure junction table:
- User_ID --> FK to Users.User_ID- Badge_ID --> FK to Badges.Badge_ID- award timestamp
So for "what badges does user X have":
1. Users → user master list2. Badges → badge definitions (name, description, icon, retroactive flag)3. Badges_Users → one row per user-badge award
Ranks work differently — 1:1, stored as Users.rank_id referencing Ranks. Rank history (not just current) is in User_Node_Ranking (tblia_user_node_ranking).
Full schema is in the *Khoros Community Standard XML Export Description* document bundled with export delivery. If you don't have a copy, you can request on via the support portal.
