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
Post a Comment