{"action":"opened","issue":{"url":"https://api.github.com/repos/lingdb/CoBL/issues/358","repository_url":"https://api.github.com/repos/lingdb/CoBL","labels_url":"https://api.github.com/repos/lingdb/CoBL/issues/358/labels{/name}","comments_url":"https://api.github.com/repos/lingdb/CoBL/issues/358/comments","events_url":"https://api.github.com/repos/lingdb/CoBL/issues/358/events","html_url":"https://github.com/lingdb/CoBL/issues/358","id":191525895,"number":358,"title":"citations are stored twice in the tables","user":{"login":"nitsnatsnok","id":2664162,"avatar_url":"https://avatars.githubusercontent.com/u/2664162?v=3","gravatar_id":"","url":"https://api.github.com/users/nitsnatsnok","html_url":"https://github.com/nitsnatsnok","followers_url":"https://api.github.com/users/nitsnatsnok/followers","following_url":"https://api.github.com/users/nitsnatsnok/following{/other_user}","gists_url":"https://api.github.com/users/nitsnatsnok/gists{/gist_id}","starred_url":"https://api.github.com/users/nitsnatsnok/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nitsnatsnok/subscriptions","organizations_url":"https://api.github.com/users/nitsnatsnok/orgs","repos_url":"https://api.github.com/users/nitsnatsnok/repos","events_url":"https://api.github.com/users/nitsnatsnok/events{/privacy}","received_events_url":"https://api.github.com/users/nitsnatsnok/received_events","type":"User","site_admin":false},"labels":[{"id":320889096,"url":"https://api.github.com/repos/lingdb/CoBL/labels/1st","name":"1st","color":"e11d21","default":false},{"id":277025766,"url":"https://api.github.com/repos/lingdb/CoBL/labels/Website:%20Bug","name":"Website: Bug","color":"f7c6c7","default":false}],"state":"open","locked":false,"assignee":{"login":"runjak","id":5417642,"avatar_url":"https://avatars.githubusercontent.com/u/5417642?v=3","gravatar_id":"","url":"https://api.github.com/users/runjak","html_url":"https://github.com/runjak","followers_url":"https://api.github.com/users/runjak/followers","following_url":"https://api.github.com/users/runjak/following{/other_user}","gists_url":"https://api.github.com/users/runjak/gists{/gist_id}","starred_url":"https://api.github.com/users/runjak/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/runjak/subscriptions","organizations_url":"https://api.github.com/users/runjak/orgs","repos_url":"https://api.github.com/users/runjak/repos","events_url":"https://api.github.com/users/runjak/events{/privacy}","received_events_url":"https://api.github.com/users/runjak/received_events","type":"User","site_admin":false},"assignees":[{"login":"runjak","id":5417642,"avatar_url":"https://avatars.githubusercontent.com/u/5417642?v=3","gravatar_id":"","url":"https://api.github.com/users/runjak","html_url":"https://github.com/runjak","followers_url":"https://api.github.com/users/runjak/followers","following_url":"https://api.github.com/users/runjak/following{/other_user}","gists_url":"https://api.github.com/users/runjak/gists{/gist_id}","starred_url":"https://api.github.com/users/runjak/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/runjak/subscriptions","organizations_url":"https://api.github.com/users/runjak/orgs","repos_url":"https://api.github.com/users/runjak/repos","events_url":"https://api.github.com/users/runjak/events{/privacy}","received_events_url":"https://api.github.com/users/runjak/received_events","type":"User","site_admin":false},{"login":"khoidt","id":7487683,"avatar_url":"https://avatars.githubusercontent.com/u/7487683?v=3","gravatar_id":"","url":"https://api.github.com/users/khoidt","html_url":"https://github.com/khoidt","followers_url":"https://api.github.com/users/khoidt/followers","following_url":"https://api.github.com/users/khoidt/following{/other_user}","gists_url":"https://api.github.com/users/khoidt/gists{/gist_id}","starred_url":"https://api.github.com/users/khoidt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/khoidt/subscriptions","organizations_url":"https://api.github.com/users/khoidt/orgs","repos_url":"https://api.github.com/users/khoidt/repos","events_url":"https://api.github.com/users/khoidt/events{/privacy}","received_events_url":"https://api.github.com/users/khoidt/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2016-11-24T13:55:39Z","updated_at":"2016-11-24T13:55:39Z","closed_at":null,"body":"Correct my if I'm wrong here, but to me it seems like citations are stored twice in the tables, cf. lexicon_cognateclasscitation:\r\n![2016-11-24-144150_1366x768_scrot](https://cloud.githubusercontent.com/assets/2664162/20600714/415721c4-b255-11e6-90dc-3613a1681b53.png)\r\nThe same applies to lexicon_cognatejudgementcitation and lexicon_lexemecitation as well, and this seems to yield strange behaviour and orphan entries as described in [this comment](https://github.com/lingdb/CoBL/issues/332#issuecomment-262776327)."}}
{"actor":{"display_login":"nitsnatsnok"}}