{"action":"created","issue":{"url":"https://api.github.com/repos/tsbutler/02-29-pair-project/issues/8","repository_url":"https://api.github.com/repos/tsbutler/02-29-pair-project","labels_url":"https://api.github.com/repos/tsbutler/02-29-pair-project/issues/8/labels{/name}","comments_url":"https://api.github.com/repos/tsbutler/02-29-pair-project/issues/8/comments","events_url":"https://api.github.com/repos/tsbutler/02-29-pair-project/issues/8/events","html_url":"https://github.com/tsbutler/02-29-pair-project/issues/8","id":137390331,"number":8,"title":"define_schema","user":{"login":"mel-d","id":16277895,"avatar_url":"https://avatars.githubusercontent.com/u/16277895?v=3","gravatar_id":"","url":"https://api.github.com/users/mel-d","html_url":"https://github.com/mel-d","followers_url":"https://api.github.com/users/mel-d/followers","following_url":"https://api.github.com/users/mel-d/following{/other_user}","gists_url":"https://api.github.com/users/mel-d/gists{/gist_id}","starred_url":"https://api.github.com/users/mel-d/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mel-d/subscriptions","organizations_url":"https://api.github.com/users/mel-d/orgs","repos_url":"https://api.github.com/users/mel-d/repos","events_url":"https://api.github.com/users/mel-d/events{/privacy}","received_events_url":"https://api.github.com/users/mel-d/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2016-02-29T21:59:07Z","updated_at":"2016-02-29T23:00:35Z","closed_at":null,"body":"DB.define_table(\"users\")\r\nDB.define_column(\"users\", \"username\", \"string\")\r\nDB.define_column(\"users\", \"password\", \"password\")\r\nDB.define_column(\"users\", \"budget\", \"integer\")\r\nDB.define_column(\"users\", \"destination_id_1\", \"integer\")\r\nDB.define_column(\"users\", \"destination_id_2\", \"integer\")\r\nDB.define_column(\"users\", \"destination_id_3\", \"integer\")\r\nDB.define_column(\"users\", \"destination_id_4\", \"integer\")\r\nDB.define_column(\"users\", \"destination_id_5\", \"integer\")\r\n\r\nDB.define_table(\"destinations\")\r\nDB.define_column(\"destinations\", \"name\", \"string\")\r\nDB.define_column(\"destinations\", \"price\", \"decimal\")"},"comment":{"url":"https://api.github.com/repos/tsbutler/02-29-pair-project/issues/comments/190438520","html_url":"https://github.com/tsbutler/02-29-pair-project/issues/8#issuecomment-190438520","issue_url":"https://api.github.com/repos/tsbutler/02-29-pair-project/issues/8","id":190438520,"user":{"login":"sumeetjain","id":29388,"avatar_url":"https://avatars.githubusercontent.com/u/29388?v=3","gravatar_id":"","url":"https://api.github.com/users/sumeetjain","html_url":"https://github.com/sumeetjain","followers_url":"https://api.github.com/users/sumeetjain/followers","following_url":"https://api.github.com/users/sumeetjain/following{/other_user}","gists_url":"https://api.github.com/users/sumeetjain/gists{/gist_id}","starred_url":"https://api.github.com/users/sumeetjain/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sumeetjain/subscriptions","organizations_url":"https://api.github.com/users/sumeetjain/orgs","repos_url":"https://api.github.com/users/sumeetjain/repos","events_url":"https://api.github.com/users/sumeetjain/events{/privacy}","received_events_url":"https://api.github.com/users/sumeetjain/received_events","type":"User","site_admin":false},"created_at":"2016-02-29T23:00:35Z","updated_at":"2016-02-29T23:00:35Z","body":"I also suggest making a new table to bridge destinations and users, instead of storing all those destination foreign keys in the 'users' table."}}