{"action":"created","issue":{"url":"https://api.github.com/repos/chop-dbhi/data-models/issues/92","labels_url":"https://api.github.com/repos/chop-dbhi/data-models/issues/92/labels{/name}","comments_url":"https://api.github.com/repos/chop-dbhi/data-models/issues/92/comments","events_url":"https://api.github.com/repos/chop-dbhi/data-models/issues/92/events","html_url":"https://github.com/chop-dbhi/data-models/issues/92","id":108023366,"number":92,"title":"Ability to classify tables/fields within a model","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":2,"created_at":"2015-09-23T22:52:29Z","updated_at":"2015-09-24T18:24:50Z","closed_at":null,"body":"Sometimes I wish I could distinguish between the PEDSnet vocabulary tables and the core tables.  Maybe I want a tags column for tables (and fields?), or maybe I want the vocabulary to be a separate data model that can be composed into the PEDSnet model .... Thoughts?"},"comment":{"url":"https://api.github.com/repos/chop-dbhi/data-models/issues/comments/143011471","html_url":"https://github.com/chop-dbhi/data-models/issues/92#issuecomment-143011471","issue_url":"https://api.github.com/repos/chop-dbhi/data-models/issues/92","id":143011471,"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},"created_at":"2015-09-24T18:24:50Z","updated_at":"2015-09-24T18:24:50Z","body":"Yes, knowing which tables are the vocab tables.  The use case at hand is wanting to automatically denormalize references from the main tables to concept.concept_name via concept.concept_id.  This is a hack but involves finding all columns named *_concept_id that are not in vocabulary tables and creating new *_concept_name columns.  There probably aren't enough use cases to justify this, but I thought I'd mention it."}}