{"action":"created","issue":{"url":"https://api.github.com/repos/simon-andrews/movieman2/issues/14","labels_url":"https://api.github.com/repos/simon-andrews/movieman2/issues/14/labels{/name}","comments_url":"https://api.github.com/repos/simon-andrews/movieman2/issues/14/comments","events_url":"https://api.github.com/repos/simon-andrews/movieman2/issues/14/events","html_url":"https://github.com/simon-andrews/movieman2/issues/14","id":78277079,"number":14,"title":"Votes table","user":{"login":"Math-ias","id":5589376,"avatar_url":"https://avatars.githubusercontent.com/u/5589376?v=3","gravatar_id":"","url":"https://api.github.com/users/Math-ias","html_url":"https://github.com/Math-ias","followers_url":"https://api.github.com/users/Math-ias/followers","following_url":"https://api.github.com/users/Math-ias/following{/other_user}","gists_url":"https://api.github.com/users/Math-ias/gists{/gist_id}","starred_url":"https://api.github.com/users/Math-ias/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Math-ias/subscriptions","organizations_url":"https://api.github.com/users/Math-ias/orgs","repos_url":"https://api.github.com/users/Math-ias/repos","events_url":"https://api.github.com/users/Math-ias/events{/privacy}","received_events_url":"https://api.github.com/users/Math-ias/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-05-19T22:36:15Z","updated_at":"2015-05-19T23:54:58Z","closed_at":null,"body":"Instead of having a vote count on each row of the movie table, there should be a votes table that tracks who voted for what. While this information won't necessarily be displayed, *in fact I don't think it should as that will affect if users vote for movies or not*, the votes table would also include things like the date of when it was upvoted, this will be good data for fancy graphs that I want to be on the page.\r\n\r\nIt might be useful to brainstorm what columns to create such as:\r\n* Having a timestamp that records when a vote was passed.\r\n* Having an ip address (hashed of course for security) /or a user account that says where the vote came from, though not displayed to the public this would be good for checking if someone is just voting on all of the movies, in the end it's just data\r\n* Having a foreign key pointing to what the vote is voting for in the movies table"},"comment":{"url":"https://api.github.com/repos/simon-andrews/movieman2/issues/comments/103699957","html_url":"https://github.com/simon-andrews/movieman2/issues/14#issuecomment-103699957","issue_url":"https://api.github.com/repos/simon-andrews/movieman2/issues/14","id":103699957,"user":{"login":"simon-andrews","id":4085067,"avatar_url":"https://avatars.githubusercontent.com/u/4085067?v=3","gravatar_id":"","url":"https://api.github.com/users/simon-andrews","html_url":"https://github.com/simon-andrews","followers_url":"https://api.github.com/users/simon-andrews/followers","following_url":"https://api.github.com/users/simon-andrews/following{/other_user}","gists_url":"https://api.github.com/users/simon-andrews/gists{/gist_id}","starred_url":"https://api.github.com/users/simon-andrews/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/simon-andrews/subscriptions","organizations_url":"https://api.github.com/users/simon-andrews/orgs","repos_url":"https://api.github.com/users/simon-andrews/repos","events_url":"https://api.github.com/users/simon-andrews/events{/privacy}","received_events_url":"https://api.github.com/users/simon-andrews/received_events","type":"User","site_admin":false},"created_at":"2015-05-19T23:54:58Z","updated_at":"2015-05-19T23:54:58Z","body":"I like it. Perhaps a Vote model? Keeping track of votes would be a good thing so that scores can be validated to make sure no one is rigging the system.\r\n\r\nThe vote count field is for the vote count on TMDb. I should have documented that; my bad. I'll be making a big documentation commit sometime soon."}}