{"action":"opened","issue":{"url":"https://api.github.com/repos/taoyds/spider/issues/19","repository_url":"https://api.github.com/repos/taoyds/spider","labels_url":"https://api.github.com/repos/taoyds/spider/issues/19/labels{/name}","comments_url":"https://api.github.com/repos/taoyds/spider/issues/19/comments","events_url":"https://api.github.com/repos/taoyds/spider/issues/19/events","html_url":"https://github.com/taoyds/spider/issues/19","id":394300339,"node_id":"MDU6SXNzdWUzOTQzMDAzMzk=","number":19,"title":"Missing join relations","user":{"login":"GaoyanCheerup","id":5237546,"node_id":"MDQ6VXNlcjUyMzc1NDY=","avatar_url":"https://avatars1.githubusercontent.com/u/5237546?v=4","gravatar_id":"","url":"https://api.github.com/users/GaoyanCheerup","html_url":"https://github.com/GaoyanCheerup","followers_url":"https://api.github.com/users/GaoyanCheerup/followers","following_url":"https://api.github.com/users/GaoyanCheerup/following{/other_user}","gists_url":"https://api.github.com/users/GaoyanCheerup/gists{/gist_id}","starred_url":"https://api.github.com/users/GaoyanCheerup/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GaoyanCheerup/subscriptions","organizations_url":"https://api.github.com/users/GaoyanCheerup/orgs","repos_url":"https://api.github.com/users/GaoyanCheerup/repos","events_url":"https://api.github.com/users/GaoyanCheerup/events{/privacy}","received_events_url":"https://api.github.com/users/GaoyanCheerup/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-12-27T05:43:51Z","updated_at":"2018-12-27T05:43:51Z","closed_at":null,"author_association":"NONE","body":"Hi Tao,\r\n\r\nI found that some missing foreign key relations in schema.json, For example, in this SQL, city Join with countrylanguage, but there is no foreign keys between city.CountryCode and countryLanguage.CountryCode in schema.json. Please help double check, thanks. \r\nSELECT T1.Name ,  T1.Population FROM city AS T1 JOIN countrylanguage AS T2 ON T1.CountryCode  =  T2.CountryCode WHERE T2.Language  =  \"English\" ORDER BY T1.Population DESC LIMIT 1\r\n"}}
{"actor":{"display_login":"GaoyanCheerup"}}