{"action":"created","issue":{"url":"https://api.github.com/repos/informatics-isi-edu/cirm-project/issues/32","repository_url":"https://api.github.com/repos/informatics-isi-edu/cirm-project","labels_url":"https://api.github.com/repos/informatics-isi-edu/cirm-project/issues/32/labels{/name}","comments_url":"https://api.github.com/repos/informatics-isi-edu/cirm-project/issues/32/comments","events_url":"https://api.github.com/repos/informatics-isi-edu/cirm-project/issues/32/events","html_url":"https://github.com/informatics-isi-edu/cirm-project/issues/32","id":180368082,"number":32,"title":"Convert vocabulary-like tables to follow Chado pattern","user":{"login":"robes","id":4202842,"avatar_url":"https://avatars.githubusercontent.com/u/4202842?v=3","gravatar_id":"","url":"https://api.github.com/users/robes","html_url":"https://github.com/robes","followers_url":"https://api.github.com/users/robes/followers","following_url":"https://api.github.com/users/robes/following{/other_user}","gists_url":"https://api.github.com/users/robes/gists{/gist_id}","starred_url":"https://api.github.com/users/robes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robes/subscriptions","organizations_url":"https://api.github.com/users/robes/orgs","repos_url":"https://api.github.com/users/robes/repos","events_url":"https://api.github.com/users/robes/events{/privacy}","received_events_url":"https://api.github.com/users/robes/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"svoinea","id":1609577,"avatar_url":"https://avatars.githubusercontent.com/u/1609577?v=3","gravatar_id":"","url":"https://api.github.com/users/svoinea","html_url":"https://github.com/svoinea","followers_url":"https://api.github.com/users/svoinea/followers","following_url":"https://api.github.com/users/svoinea/following{/other_user}","gists_url":"https://api.github.com/users/svoinea/gists{/gist_id}","starred_url":"https://api.github.com/users/svoinea/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/svoinea/subscriptions","organizations_url":"https://api.github.com/users/svoinea/orgs","repos_url":"https://api.github.com/users/svoinea/repos","events_url":"https://api.github.com/users/svoinea/events{/privacy}","received_events_url":"https://api.github.com/users/svoinea/received_events","type":"User","site_admin":false},"assignees":[{"login":"svoinea","id":1609577,"avatar_url":"https://avatars.githubusercontent.com/u/1609577?v=3","gravatar_id":"","url":"https://api.github.com/users/svoinea","html_url":"https://github.com/svoinea","followers_url":"https://api.github.com/users/svoinea/followers","following_url":"https://api.github.com/users/svoinea/following{/other_user}","gists_url":"https://api.github.com/users/svoinea/gists{/gist_id}","starred_url":"https://api.github.com/users/svoinea/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/svoinea/subscriptions","organizations_url":"https://api.github.com/users/svoinea/orgs","repos_url":"https://api.github.com/users/svoinea/repos","events_url":"https://api.github.com/users/svoinea/events{/privacy}","received_events_url":"https://api.github.com/users/svoinea/received_events","type":"User","site_admin":false}],"milestone":null,"comments":3,"created_at":"2016-09-30T18:13:57Z","updated_at":"2016-10-01T01:02:40Z","closed_at":null,"body":"The Chado pattern is described here:\r\nhttps://github.com/informatics-isi-edu/ermrest/blob/dcbb5aeba20b5171c50e9362a060826144dcf497/user-doc/Chado-patterns.md\r\n\r\nLet's convert the CIRM vocabulary tables to use this pattern. If there are issues, we can revisit or modify the pattern."},"comment":{"url":"https://api.github.com/repos/informatics-isi-edu/cirm-project/issues/comments/250882952","html_url":"https://github.com/informatics-isi-edu/cirm-project/issues/32#issuecomment-250882952","issue_url":"https://api.github.com/repos/informatics-isi-edu/cirm-project/issues/32","id":250882952,"user":{"login":"karlcz","id":1075148,"avatar_url":"https://avatars.githubusercontent.com/u/1075148?v=3","gravatar_id":"","url":"https://api.github.com/users/karlcz","html_url":"https://github.com/karlcz","followers_url":"https://api.github.com/users/karlcz/followers","following_url":"https://api.github.com/users/karlcz/following{/other_user}","gists_url":"https://api.github.com/users/karlcz/gists{/gist_id}","starred_url":"https://api.github.com/users/karlcz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/karlcz/subscriptions","organizations_url":"https://api.github.com/users/karlcz/orgs","repos_url":"https://api.github.com/users/karlcz/repos","events_url":"https://api.github.com/users/karlcz/events{/privacy}","received_events_url":"https://api.github.com/users/karlcz/received_events","type":"User","site_admin":false},"created_at":"2016-10-01T01:02:40Z","updated_at":"2016-10-01T01:02:40Z","body":"I would argue strongly against using a database \"serial\" column to\nform the dbxref values.\n\nWe want dbxref values to be URN-like so they can be a stable\nserialization format for a vocabulary. They must work across catalogs\nthat might share the same vocabulary, and not leak out any local\ndatabase state variations. They are much like accession numbers. The\nonly way a \"serial\" column could fulfill this role would be to operate\na durable registry and issue the dbxref once, then always transport a\nstable copy of this registry content to other replicated instances of\nthe vocabulary (without using a serial generator on those).\n\nI also think that a human-friendly, short text dbxref should be\npreferred to a numeric accession ID. These should appear in data\nimport/export and be meaningful to the human experts who have to look\nat these data. From your example, I'd do something more like\n`CIRM_AGE_STATE:7w4d` etc.\n\n\n"}}
{"actor":{"display_login":"karlcz"}}