{"action":"created","issue":{"url":"https://api.github.com/repos/wanghaisheng/OHDSI-Research/issues/4","labels_url":"https://api.github.com/repos/wanghaisheng/OHDSI-Research/issues/4/labels{/name}","comments_url":"https://api.github.com/repos/wanghaisheng/OHDSI-Research/issues/4/comments","events_url":"https://api.github.com/repos/wanghaisheng/OHDSI-Research/issues/4/events","html_url":"https://github.com/wanghaisheng/OHDSI-Research/issues/4","id":55022693,"number":4,"title":"CDM数据模型","user":{"login":"wanghaisheng","id":2363295,"avatar_url":"https://avatars.githubusercontent.com/u/2363295?v=3","gravatar_id":"","url":"https://api.github.com/users/wanghaisheng","html_url":"https://github.com/wanghaisheng","followers_url":"https://api.github.com/users/wanghaisheng/followers","following_url":"https://api.github.com/users/wanghaisheng/following{/other_user}","gists_url":"https://api.github.com/users/wanghaisheng/gists{/gist_id}","starred_url":"https://api.github.com/users/wanghaisheng/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wanghaisheng/subscriptions","organizations_url":"https://api.github.com/users/wanghaisheng/orgs","repos_url":"https://api.github.com/users/wanghaisheng/repos","events_url":"https://api.github.com/users/wanghaisheng/events{/privacy}","received_events_url":"https://api.github.com/users/wanghaisheng/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"wanghaisheng","id":2363295,"avatar_url":"https://avatars.githubusercontent.com/u/2363295?v=3","gravatar_id":"","url":"https://api.github.com/users/wanghaisheng","html_url":"https://github.com/wanghaisheng","followers_url":"https://api.github.com/users/wanghaisheng/followers","following_url":"https://api.github.com/users/wanghaisheng/following{/other_user}","gists_url":"https://api.github.com/users/wanghaisheng/gists{/gist_id}","starred_url":"https://api.github.com/users/wanghaisheng/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wanghaisheng/subscriptions","organizations_url":"https://api.github.com/users/wanghaisheng/orgs","repos_url":"https://api.github.com/users/wanghaisheng/repos","events_url":"https://api.github.com/users/wanghaisheng/events{/privacy}","received_events_url":"https://api.github.com/users/wanghaisheng/received_events","type":"User","site_admin":false},"milestone":null,"comments":34,"created_at":"2015-01-21T14:05:58Z","updated_at":"2015-03-17T15:16:18Z","closed_at":null,"body":"OMOP上的常见查询示例\r\n普通表的\r\nhttp://cdmqueries.omop.org\r\n针对术语的\r\nhttp://vocabqueries.omop.org/home"},"comment":{"url":"https://api.github.com/repos/wanghaisheng/OHDSI-Research/issues/comments/82404057","html_url":"https://github.com/wanghaisheng/OHDSI-Research/issues/4#issuecomment-82404057","issue_url":"https://api.github.com/repos/wanghaisheng/OHDSI-Research/issues/4","id":82404057,"user":{"login":"wanghaisheng","id":2363295,"avatar_url":"https://avatars.githubusercontent.com/u/2363295?v=3","gravatar_id":"","url":"https://api.github.com/users/wanghaisheng","html_url":"https://github.com/wanghaisheng","followers_url":"https://api.github.com/users/wanghaisheng/followers","following_url":"https://api.github.com/users/wanghaisheng/following{/other_user}","gists_url":"https://api.github.com/users/wanghaisheng/gists{/gist_id}","starred_url":"https://api.github.com/users/wanghaisheng/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wanghaisheng/subscriptions","organizations_url":"https://api.github.com/users/wanghaisheng/orgs","repos_url":"https://api.github.com/users/wanghaisheng/repos","events_url":"https://api.github.com/users/wanghaisheng/events{/privacy}","received_events_url":"https://api.github.com/users/wanghaisheng/received_events","type":"User","site_admin":false},"created_at":"2015-03-17T15:16:18Z","updated_at":"2015-03-17T15:16:18Z","body":"### CARE_SITE table\r\n\r\n<div class=\"level2\">\r\n\r\nThe CARE_SITE table contains a list of uniquely identified institutional (physical or organizational) units where healthcare delivery is practiced (offices, wards, hospitals, clinics, etc.).\r\n\r\n<div class=\"table sectionedit2\"><table class=\"inline\">\r\n\t<thead>\r\n\t<tr class=\"row0\">\r\n\t\t<th class=\"col0\">Field</th><th class=\"col1\">Required</th><th class=\"col2\">Type</th><th class=\"col3\">Description</th>\r\n\t</tr>\r\n\t</thead>\r\n\t<tr class=\"row1\">\r\n\t\t<td class=\"col0\">care_site_id</td><td class=\"col1\">Yes</td><td class=\"col2\">integer</td><td class=\"col3\">A unique identifier for each Care Site.</td>\r\n\t</tr>\r\n\t<tr class=\"row2\">\r\n\t\t<td class=\"col0\">care_site_name</td><td class=\"col1\">No</td><td class=\"col2\">varchar(255)</td><td class=\"col3\">The description or name of the Care Site</td>\r\n\t</tr>\r\n\t<tr class=\"row3\">\r\n\t\t<td class=\"col0\">place_of_service_concept_id</td><td class=\"col1\">No</td><td class=\"col2\">integer</td><td class=\"col3\">A foreign key that refers to a Place of Service Concept ID in the Standardized Vocabularies.</td>\r\n\t</tr>\r\n\t<tr class=\"row4\">\r\n\t\t<td class=\"col0\">location_id</td><td class=\"col1\">No</td><td class=\"col2\">integer</td><td class=\"col3\">A foreign key to the geographic Location of the Care Site in the LOCATION table, where the detailed address information is stored.</td>\r\n\t</tr>\r\n\t<tr class=\"row5\">\r\n\t\t<td class=\"col0\">care_site_source_value</td><td class=\"col1\">No</td><td class=\"col2\">varchar(50)</td><td class=\"col3\">The identifier for the Care Site in the source data, stored here for reference.</td>\r\n\t</tr>\r\n\t<tr class=\"row6\">\r\n\t\t<td class=\"col0\">place_of_service_source_value</td><td class=\"col1\">No</td><td class=\"col2\">varchar(50)</td><td class=\"col3\">The source code for the Place of Service as it appears in the source data, stored here for reference.</td>\r\n\t</tr>\r\n</table></div>\r\n\r\n</div>\r\n\r\n### Conventions\r\n\r\n<div class=\"level3\">\r\n\r\n*   <div class=\"li\"> Many sources do not make a distinction between individual and institutional providers. The CARE_SITE table contains the institutional providers.</div>\r\n\r\n*   <div class=\"li\"> If the source, instead of uniquely identifying individual Care Sites, only provides limited information such as Place of Service, generic or “pooled” Care Site records are listed in the CARE_SITE table.</div>\r\n\r\n*   <div class=\"li\"> There are hierarchical and business relationships between Care Sites. For example,wards can belong to clinics or departments, which can in turn belong to hospitals, which in turn can belong to hospital systems, which in turn can belong to HMOs.</div>\r\n\r\n*   <div class=\"li\"> The relationships between Care Sites are defined in the FACT_RELATIONSHIP table.</div>\r\n\r\n*   <div class=\"li\"> The Care Site Source Value typically contains the name of the Care Site.</div>\r\n\r\n*   <div class=\"li\"> The Place of Service Concepts belongs to the Domain &#039;Place of Service&#039;.</div>\r\n\r\n</div>"}}