{"action":"created","issue":{"url":"https://api.github.com/repos/chop-dbhi/data-models/issues/101","labels_url":"https://api.github.com/repos/chop-dbhi/data-models/issues/101/labels{/name}","comments_url":"https://api.github.com/repos/chop-dbhi/data-models/issues/101/comments","events_url":"https://api.github.com/repos/chop-dbhi/data-models/issues/101/events","html_url":"https://github.com/chop-dbhi/data-models/pull/101","id":112216818,"number":101,"title":"PR: Add missing *_concept_id foreign key constraints","user":{"login":"murphyke","id":928642,"avatar_url":"https://avatars.githubusercontent.com/u/928642?v=3","gravatar_id":"","url":"https://api.github.com/users/murphyke","html_url":"https://github.com/murphyke","followers_url":"https://api.github.com/users/murphyke/followers","following_url":"https://api.github.com/users/murphyke/following{/other_user}","gists_url":"https://api.github.com/users/murphyke/gists{/gist_id}","starred_url":"https://api.github.com/users/murphyke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/murphyke/subscriptions","organizations_url":"https://api.github.com/users/murphyke/orgs","repos_url":"https://api.github.com/users/murphyke/repos","events_url":"https://api.github.com/users/murphyke/events{/privacy}","received_events_url":"https://api.github.com/users/murphyke/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-10-19T19:38:51Z","updated_at":"2015-11-04T16:46:40Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/chop-dbhi/data-models/pulls/101","html_url":"https://github.com/chop-dbhi/data-models/pull/101","diff_url":"https://github.com/chop-dbhi/data-models/pull/101.diff","patch_url":"https://github.com/chop-dbhi/data-models/pull/101.patch"},"body":"Fix #94.  Add constraints on:\r\n\r\n* care_site.specialty_concept_id\r\n* concept_synonym.language_concept_id\r\n* source_to_concept_map.source_concept_id\r\n\r\nand bump the `release_serial` value in models.csv from 3 to 4.\r\n\r\nHopefully there is not a good reason why these fields do not have foreign key constraints on them.  Maybe @aaron0browne should take a glance."},"comment":{"url":"https://api.github.com/repos/chop-dbhi/data-models/issues/comments/153788363","html_url":"https://github.com/chop-dbhi/data-models/pull/101#issuecomment-153788363","issue_url":"https://api.github.com/repos/chop-dbhi/data-models/issues/101","id":153788363,"user":{"login":"aaron0browne","id":3409975,"avatar_url":"https://avatars.githubusercontent.com/u/3409975?v=3","gravatar_id":"","url":"https://api.github.com/users/aaron0browne","html_url":"https://github.com/aaron0browne","followers_url":"https://api.github.com/users/aaron0browne/followers","following_url":"https://api.github.com/users/aaron0browne/following{/other_user}","gists_url":"https://api.github.com/users/aaron0browne/gists{/gist_id}","starred_url":"https://api.github.com/users/aaron0browne/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aaron0browne/subscriptions","organizations_url":"https://api.github.com/users/aaron0browne/orgs","repos_url":"https://api.github.com/users/aaron0browne/repos","events_url":"https://api.github.com/users/aaron0browne/events{/privacy}","received_events_url":"https://api.github.com/users/aaron0browne/received_events","type":"User","site_admin":false},"created_at":"2015-11-04T16:46:40Z","updated_at":"2015-11-04T16:46:40Z","body":"LGTM, but please bump the PEDSnet v2.1 release serial value as well."}}