[New feature] Add Level System and XP

[xXPinkmagicXx]

By adding this we can give the users motivation to come back to their character/person to level up.

The experience points would be gained by

• Finishing an article
• Finishing an exercise
• By doing stuff basically

[xXPinkmagicXx]

classDiagram

class xp_events {
  id
  user_id
  source_type
  exercise_source_id
  xp_amount
  created_at
}

class users_xp {
  id 
  user_id
  total_xp
  total_xp_for_next_level
  current_level
}

class levels {
  level_number
  xp_required_total
  title : string
  badge_icon?
}

class level_up_events {
  id
  user_id
  old_level
  new_level
  created_at
}

%% Relationships (inferred from FKs)

xp_events --> users_xp : belongs to user
users_xp --> levels : current_level
level_up_events --> users_xp : triggered by user
level_up_events --> levels : new_level

Loading