Finalize Schema - Githubissues

Amar-Gill / Pro-DucKtivity-Warz

Competitive habit tracking app

0 stars 1 forks source link

Finalize Schema #9

Open Amar-Gill opened 4 years ago

Amar-Gill commented 4 years ago

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

Amar-Gill commented 4 years ago

habit_wars_schema_finalized

Amar-Gill commented 4 years ago

project_schema_final_final