{"action":"closed","issue":{"url":"https://api.github.com/repos/heroix/rant-ruby/issues/1","labels_url":"https://api.github.com/repos/heroix/rant-ruby/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/heroix/rant-ruby/issues/1/comments","events_url":"https://api.github.com/repos/heroix/rant-ruby/issues/1/events","html_url":"https://github.com/heroix/rant-ruby/issues/1","id":56161352,"number":1,"title":"Create the initial model","user":{"login":"heroix","id":753219,"avatar_url":"https://avatars.githubusercontent.com/u/753219?v=3","gravatar_id":"","url":"https://api.github.com/users/heroix","html_url":"https://github.com/heroix","followers_url":"https://api.github.com/users/heroix/followers","following_url":"https://api.github.com/users/heroix/following{/other_user}","gists_url":"https://api.github.com/users/heroix/gists{/gist_id}","starred_url":"https://api.github.com/users/heroix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/heroix/subscriptions","organizations_url":"https://api.github.com/users/heroix/orgs","repos_url":"https://api.github.com/users/heroix/repos","events_url":"https://api.github.com/users/heroix/events{/privacy}","received_events_url":"https://api.github.com/users/heroix/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/heroix/rant-ruby/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"closed","locked":false,"assignee":{"login":"heroix","id":753219,"avatar_url":"https://avatars.githubusercontent.com/u/753219?v=3","gravatar_id":"","url":"https://api.github.com/users/heroix","html_url":"https://github.com/heroix","followers_url":"https://api.github.com/users/heroix/followers","following_url":"https://api.github.com/users/heroix/following{/other_user}","gists_url":"https://api.github.com/users/heroix/gists{/gist_id}","starred_url":"https://api.github.com/users/heroix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/heroix/subscriptions","organizations_url":"https://api.github.com/users/heroix/orgs","repos_url":"https://api.github.com/users/heroix/repos","events_url":"https://api.github.com/users/heroix/events{/privacy}","received_events_url":"https://api.github.com/users/heroix/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/heroix/rant-ruby/milestones/1","html_url":"https://github.com/heroix/rant-ruby/milestones/Beta%20Launch","labels_url":"https://api.github.com/repos/heroix/rant-ruby/milestones/1/labels","id":960137,"number":1,"title":"Beta Launch","description":"First pancake of the project. Public should be able to reach production website after this milestone.","creator":{"login":"heroix","id":753219,"avatar_url":"https://avatars.githubusercontent.com/u/753219?v=3","gravatar_id":"","url":"https://api.github.com/users/heroix","html_url":"https://github.com/heroix","followers_url":"https://api.github.com/users/heroix/followers","following_url":"https://api.github.com/users/heroix/following{/other_user}","gists_url":"https://api.github.com/users/heroix/gists{/gist_id}","starred_url":"https://api.github.com/users/heroix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/heroix/subscriptions","organizations_url":"https://api.github.com/users/heroix/orgs","repos_url":"https://api.github.com/users/heroix/repos","events_url":"https://api.github.com/users/heroix/events{/privacy}","received_events_url":"https://api.github.com/users/heroix/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":2,"state":"open","created_at":"2015-02-01T12:02:17Z","updated_at":"2016-01-10T16:29:46Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2015-02-01T11:58:49Z","updated_at":"2016-01-10T16:29:46Z","closed_at":"2016-01-10T16:29:46Z","body":"Investigate how to create the initial model like this:\r\n1. Create and modify dates?\r\n2. Join tables? (PostTags)\r\n3. Join table with parameter or simple table with two foreign keys? (Upvote, RelatedTags)\r\n4. DB constraints? (RelatedTags)\r\n\r\n**Post**\r\n* id\r\n* text_id\r\n* user_id\r\n\r\n**User**\r\n* id\r\n* username\r\n* password\r\n* email\r\n\r\n**Text**\r\n* id\r\n* content\r\n\r\n**Tag**\r\n* id\r\n* value\r\n\r\n**PostTags**\r\n* post_id\r\n* tag_id\r\n\r\n**Upvote**\r\n* post_id\r\n* user_id\r\n* date_upvoted\r\n\r\n**RelatedTags**\r\n* tag1_id\r\n* tag2_id\r\n* count\r\n\r\n_(constraint tag1_id > tag2_id)_\r\n"}}