MySQL Forums
Forum List  »  Newbie

Optimal Sheet table
Posted by: Miguel Pimentel
Date: August 02, 2019 03:38PM

I am making a TTRPG character creator, think Roll20 or D&DBeyond. However, there are a wholly variable amount of skills and what their names are. I want to know what the optimal way to store that information in a database is. I know for a fact that there will be a minimum of 20 values that pertain directly to the character sheet. These are Name, Description, Photo, Refresh, Aspects[1-5], Extras, Stunts, Physical stress, Mental stress, Mild consequence, Moderate Consequence, Severe Consequence, 2nd Mild Consequence, notes, creator id, and GM id. There are, from my experience, about 10 skills in total, but it can be more, and I don't know much about their values. Again, I won't be able to know the name, or value, but it seems wasteful to make 30+ columns just a third of them to be null.

TL;DR: Making a character creator, but there's too many variables for an obvious way to properly store it.

Options: ReplyQuote


Subject
Written By
Posted
Optimal Sheet table
August 02, 2019 03:38PM
August 06, 2019 06:00AM
August 12, 2019 01:30PM
August 13, 2019 05:27AM
August 14, 2019 05:56AM
August 14, 2019 10:52AM
August 15, 2019 04:52AM
August 17, 2019 02:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.