{"action":"created","issue":{"url":"https://api.github.com/repos/biocore/american-gut-web/issues/417","labels_url":"https://api.github.com/repos/biocore/american-gut-web/issues/417/labels{/name}","comments_url":"https://api.github.com/repos/biocore/american-gut-web/issues/417/comments","events_url":"https://api.github.com/repos/biocore/american-gut-web/issues/417/events","html_url":"https://github.com/biocore/american-gut-web/pull/417","id":73756885,"number":417,"title":"Add constraints to barcode-related tables","user":{"login":"adamrp","id":2574407,"avatar_url":"https://avatars.githubusercontent.com/u/2574407?v=3","gravatar_id":"","url":"https://api.github.com/users/adamrp","html_url":"https://github.com/adamrp","followers_url":"https://api.github.com/users/adamrp/followers","following_url":"https://api.github.com/users/adamrp/following{/other_user}","gists_url":"https://api.github.com/users/adamrp/gists{/gist_id}","starred_url":"https://api.github.com/users/adamrp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adamrp/subscriptions","organizations_url":"https://api.github.com/users/adamrp/orgs","repos_url":"https://api.github.com/users/adamrp/repos","events_url":"https://api.github.com/users/adamrp/events{/privacy}","received_events_url":"https://api.github.com/users/adamrp/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-05-06T22:30:03Z","updated_at":"2015-05-06T22:40:49Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/biocore/american-gut-web/pulls/417","html_url":"https://github.com/biocore/american-gut-web/pull/417","diff_url":"https://github.com/biocore/american-gut-web/pull/417.diff","patch_url":"https://github.com/biocore/american-gut-web/pull/417.patch"},"body":"Discussed in calls and emails with @wasade and @squirrelo. These tables should have constraints. I also reorganized the layout in the DBS file so that the relationships between these tables is easier to see visually.\r\n\r\nThe test code had to be modified to comply with the new constraints."},"comment":{"url":"https://api.github.com/repos/biocore/american-gut-web/issues/comments/99632641","html_url":"https://github.com/biocore/american-gut-web/pull/417#issuecomment-99632641","issue_url":"https://api.github.com/repos/biocore/american-gut-web/issues/417","id":99632641,"user":{"login":"adamrp","id":2574407,"avatar_url":"https://avatars.githubusercontent.com/u/2574407?v=3","gravatar_id":"","url":"https://api.github.com/users/adamrp","html_url":"https://github.com/adamrp","followers_url":"https://api.github.com/users/adamrp/followers","following_url":"https://api.github.com/users/adamrp/following{/other_user}","gists_url":"https://api.github.com/users/adamrp/gists{/gist_id}","starred_url":"https://api.github.com/users/adamrp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adamrp/subscriptions","organizations_url":"https://api.github.com/users/adamrp/orgs","repos_url":"https://api.github.com/users/adamrp/repos","events_url":"https://api.github.com/users/adamrp/events{/privacy}","received_events_url":"https://api.github.com/users/adamrp/received_events","type":"User","site_admin":false},"created_at":"2015-05-06T22:40:49Z","updated_at":"2015-05-06T22:40:49Z","body":"No, I don't, actually.... there are 525 barcodes in the table, all between\n9k and 10k. The string \"barcode_exceptions\" does not appear to be  anywhere\nin this codebase nor in the labadmin codebase. Hmmmmm\n\nOn Wed, May 6, 2015 at 4:34 PM, Daniel McDonald <notifications@github.com>\nwrote:\n\n> [image: :+1:] just realized, I don't actually know what\n> barcode_exceptions is for, do you know?\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/biocore/american-gut-web/pull/417#issuecomment-99631056>\n> .\n>\n"}}