{"action":"created","issue":{"url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/issues/163","repository_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1","labels_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/issues/163/labels{/name}","comments_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/issues/163/comments","events_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/issues/163/events","html_url":"https://github.com/DecodeMTL/mysql-workshop-1/pull/163","id":132224545,"number":163,"title":"exercise-1","user":{"login":"dreboom","id":15094782,"avatar_url":"https://avatars.githubusercontent.com/u/15094782?v=3","gravatar_id":"","url":"https://api.github.com/users/dreboom","html_url":"https://github.com/dreboom","followers_url":"https://api.github.com/users/dreboom/followers","following_url":"https://api.github.com/users/dreboom/following{/other_user}","gists_url":"https://api.github.com/users/dreboom/gists{/gist_id}","starred_url":"https://api.github.com/users/dreboom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dreboom/subscriptions","organizations_url":"https://api.github.com/users/dreboom/orgs","repos_url":"https://api.github.com/users/dreboom/repos","events_url":"https://api.github.com/users/dreboom/events{/privacy}","received_events_url":"https://api.github.com/users/dreboom/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-02-08T18:40:29Z","updated_at":"2016-02-09T23:36:26Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/pulls/163","html_url":"https://github.com/DecodeMTL/mysql-workshop-1/pull/163","diff_url":"https://github.com/DecodeMTL/mysql-workshop-1/pull/163.diff","patch_url":"https://github.com/DecodeMTL/mysql-workshop-1/pull/163.patch"},"body":""},"comment":{"url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/issues/comments/182134089","html_url":"https://github.com/DecodeMTL/mysql-workshop-1/pull/163#issuecomment-182134089","issue_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/issues/163","id":182134089,"user":{"login":"ziad-saab","id":3943143,"avatar_url":"https://avatars.githubusercontent.com/u/3943143?v=3","gravatar_id":"","url":"https://api.github.com/users/ziad-saab","html_url":"https://github.com/ziad-saab","followers_url":"https://api.github.com/users/ziad-saab/followers","following_url":"https://api.github.com/users/ziad-saab/following{/other_user}","gists_url":"https://api.github.com/users/ziad-saab/gists{/gist_id}","starred_url":"https://api.github.com/users/ziad-saab/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ziad-saab/subscriptions","organizations_url":"https://api.github.com/users/ziad-saab/orgs","repos_url":"https://api.github.com/users/ziad-saab/repos","events_url":"https://api.github.com/users/ziad-saab/events{/privacy}","received_events_url":"https://api.github.com/users/ziad-saab/received_events","type":"User","site_admin":false},"created_at":"2016-02-09T23:36:26Z","updated_at":"2016-02-09T23:36:26Z","body":"@dreboom let's talk a bit about Exercise #10 the hotel challenge. There's no \"good\" or \"bad\" answer to this, but I'd like to challenge you with something.\r\n\r\nIn your model, you have a single table which has a flag (yes/no) for \"availability\". If someone calls you and says they want to reserve the room from, say, September 15 to September 18. How do you know if the room (or any room) is available during those dates?\r\n\r\nTry to see how you could extend your data schema to include the possibility of adding reservations. Each reservation entry would be linked to a room (using the room's unique identifier), and would contain the dates of the reservation. Then try to create a query that would let me know which rooms are available for a certain date range."}}