Implement Basic Statistic Functionality DB Side - Githubissues

Society-In-Shadow / ExpressedRealms

0 stars 0 forks source link

Implement Basic Statistic Functionality DB Side #86

Closed noremacskich closed 2 months ago

noremacskich commented 2 months ago

A character can have 6 stats: Agility, Constitution, Dexterity, Strength, Intelligence, Willpower.

To implement, we need the following table structure

Character:

Agility - byte - FK StatLevel Id - Default Value 1 - Required
Constitution - byte - FK StatLevel Id - Default Value 1 - Required
Dexterity - byte - FK StatLevel Id - Default Value 1 - Required
Strength - byte - FK StatLevel Id - Default Value 1 - Required
Intelligence - byte - FK StatLevel Id - Default Value 1 - Required
Willpower - byte - FK StatLevel Id - Default Value 1 - Required
ExperiencePoints - byte - Default Value 72 - Required

StatType:

Id - byte - PK - Required
Name - String 15 Characters - Required
ShortName - String 3 characters - All Caps - Required
Description - String 200 characters - Required

StatLevel

Id - byte - PK - Required
Bonus - int - Required
XP Cost - int - Required

StatDescriptionMapping

StatId - FK to Stat Type - byte - PK - Required
StatInfoId - FK to StatLevel - byte - PK - Required
ReasonableExpectation - String 400 - Required