{"action":"created","issue":{"url":"https://api.github.com/repos/tuminoid/kisakone/issues/188","labels_url":"https://api.github.com/repos/tuminoid/kisakone/issues/188/labels{/name}","comments_url":"https://api.github.com/repos/tuminoid/kisakone/issues/188/comments","events_url":"https://api.github.com/repos/tuminoid/kisakone/issues/188/events","html_url":"https://github.com/tuminoid/kisakone/issues/188","id":55744299,"number":188,"title":"Dangling references to SectionMembership in data","user":{"login":"tuminoid","id":853790,"avatar_url":"https://avatars.githubusercontent.com/u/853790?v=3","gravatar_id":"","url":"https://api.github.com/users/tuminoid","html_url":"https://github.com/tuminoid","followers_url":"https://api.github.com/users/tuminoid/followers","following_url":"https://api.github.com/users/tuminoid/following{/other_user}","gists_url":"https://api.github.com/users/tuminoid/gists{/gist_id}","starred_url":"https://api.github.com/users/tuminoid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tuminoid/subscriptions","organizations_url":"https://api.github.com/users/tuminoid/orgs","repos_url":"https://api.github.com/users/tuminoid/repos","events_url":"https://api.github.com/users/tuminoid/events{/privacy}","received_events_url":"https://api.github.com/users/tuminoid/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/tuminoid/kisakone/labels/technical","name":"technical","color":"d4c5f9"}],"state":"closed","locked":false,"assignee":{"login":"tuminoid","id":853790,"avatar_url":"https://avatars.githubusercontent.com/u/853790?v=3","gravatar_id":"","url":"https://api.github.com/users/tuminoid","html_url":"https://github.com/tuminoid","followers_url":"https://api.github.com/users/tuminoid/followers","following_url":"https://api.github.com/users/tuminoid/following{/other_user}","gists_url":"https://api.github.com/users/tuminoid/gists{/gist_id}","starred_url":"https://api.github.com/users/tuminoid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tuminoid/subscriptions","organizations_url":"https://api.github.com/users/tuminoid/orgs","repos_url":"https://api.github.com/users/tuminoid/repos","events_url":"https://api.github.com/users/tuminoid/events{/privacy}","received_events_url":"https://api.github.com/users/tuminoid/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/tuminoid/kisakone/milestones/25","labels_url":"https://api.github.com/repos/tuminoid/kisakone/milestones/25/labels","id":969883,"number":25,"title":"next","description":"","creator":{"login":"tuminoid","id":853790,"avatar_url":"https://avatars.githubusercontent.com/u/853790?v=3","gravatar_id":"","url":"https://api.github.com/users/tuminoid","html_url":"https://github.com/tuminoid","followers_url":"https://api.github.com/users/tuminoid/followers","following_url":"https://api.github.com/users/tuminoid/following{/other_user}","gists_url":"https://api.github.com/users/tuminoid/gists{/gist_id}","starred_url":"https://api.github.com/users/tuminoid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tuminoid/subscriptions","organizations_url":"https://api.github.com/users/tuminoid/orgs","repos_url":"https://api.github.com/users/tuminoid/repos","events_url":"https://api.github.com/users/tuminoid/events{/privacy}","received_events_url":"https://api.github.com/users/tuminoid/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":7,"state":"open","created_at":"2015-02-07T13:59:53Z","updated_at":"2015-02-10T10:44:28Z","due_on":"2015-02-14T22:00:00Z","closed_at":null},"comments":1,"created_at":"2015-01-28T11:25:19Z","updated_at":"2015-02-10T10:44:28Z","closed_at":"2015-02-10T10:44:28Z","body":"Some cleanup is not being done properly, adding foreign key is impossible if not cleaned up.\r\n\r\n```\r\nDELETE FROM :SectionMembership WHERE Participation NOT IN (SELECT DISTINCT id FROM :Participation);\r\nDELETE FROM :SectionMembership WHERE Section NOT IN (SELECT DISTINCT id FROM :Section);\r\n```"},"comment":{"url":"https://api.github.com/repos/tuminoid/kisakone/issues/comments/73679299","html_url":"https://github.com/tuminoid/kisakone/issues/188#issuecomment-73679299","issue_url":"https://api.github.com/repos/tuminoid/kisakone/issues/188","id":73679299,"user":{"login":"tuminoid","id":853790,"avatar_url":"https://avatars.githubusercontent.com/u/853790?v=3","gravatar_id":"","url":"https://api.github.com/users/tuminoid","html_url":"https://github.com/tuminoid","followers_url":"https://api.github.com/users/tuminoid/followers","following_url":"https://api.github.com/users/tuminoid/following{/other_user}","gists_url":"https://api.github.com/users/tuminoid/gists{/gist_id}","starred_url":"https://api.github.com/users/tuminoid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tuminoid/subscriptions","organizations_url":"https://api.github.com/users/tuminoid/orgs","repos_url":"https://api.github.com/users/tuminoid/repos","events_url":"https://api.github.com/users/tuminoid/events{/privacy}","received_events_url":"https://api.github.com/users/tuminoid/received_events","type":"User","site_admin":false},"created_at":"2015-02-10T10:44:28Z","updated_at":"2015-02-10T10:44:28Z","body":"Foreign keys are in place to avoid this."}}