I'm creating a website in which people can submit there own lists, and then essentially others Up/Down Vote the items within the list. I'd like the list (If the submitter allows "votes") to be ordered by the amount of votes (Easy Enough to do in SQL I know).
However, my issue is with the DB Design, I don't know how to design it to make it work.
So far my Idea is:
Lists Table: ListID, ListDescription, ListItem(x [e.g. 1, 2, 3 4]), CreatedDate, UserID (if it is user submitted).
Votes Table: VoteID, ListID
I can't quite get my head round, how to setup the votes table to record votes for each item in the specified list?
Could anyone help please?
Thanks