How do I organize tables for simple lottery game? mysql
I'd create another table to store the number range each week (store the date and range) and then another table to store the user's selection (store the user id, date, and chosen number).