mysql - Database Design daily data -


i have question database design, i'm wondering how go saving daily user data.

for example have table called accounts

structure accountid, accountname, dailyscore, winrate

how can keep track of dailyscore , winrate each day. keep creating tables named after date or there better way.

accounts has info each "account" -- account_id, name, etc. table rather static -- add row, , change something.

scores has new rows every day -- account_id, date, score, etc. primary key have 2 columns: account_id , date.

not knowing how winrate calculated, unclear where, if anywhere, should stored. calculated scores??


Comments

Popular posts from this blog

toolbar - How to add link to user registration inside toobar in admin joomla 3 custom component -

linux - disk space limitation when creating war file -