Schema - Amar-Gill/Pro-DucKtivity-Warz GitHub Wiki

User

  • username - Charfield
  • email - Charfield
  • password (hashed) - Charfield

Game

  • p1 (initiator) - Foreignkey
  • p2 - Foreignkey
  • p1 habits array (max 3) - Array of Foreignkeys
  • p2 habits array (max3) - Array of Foreignkeys
  • p1 score
  • p2 score

Round

  • game - Foreignkey
  • p1 rolls x3 - Intfield
  • p2 rolls x3 - Intfield
  • p1 initiative - Intfield
  • p2 initiative - Intfield
  • p1 atk - Intfield
  • p1 hp - Intfield
  • p1 luck - Intfield
  • p2 atk - Intfield
  • p2 hp - Intfield
  • p2 luck - Intfield
  • p1 dmg array - Array of Intfield
  • p2 dmg array - Array of Intfield
  • Result (which player wins) - Foreignkey

Habit

  • game - Foreignkey
  • user - Foreignkey
  • name - Charfield
  • Frequency - Intfield

Log Habit

  • habit - Foreignkey
  • sender - Foreignkey
  • approved - Booleanfield
  • image_path - Charfield