官方wiki—读文档时遇到的问题

[wanghaisheng]

1、http://www.ohdsi.org/web/wiki/doku.php?id=documentation:cdm:vocabulary 在介绍vocabulary这张表时，提到的reference表在何处 完全找不到

VOCABULARY表中罗列了从各处收集而来的字典，亦或是OMOP自己构造的。This reference table is populated with a single record for each Vocabulary source and includes a descriptive name and other associated attributes for the Vocabulary.

[wanghaisheng]

RELATIONSHIP table 表中的 relationship_concept_id Yes integer A foreign key that refers to an identifier in the CONCEPT table for the unique relationship concep

这个字段是什么用途

[wanghaisheng]

SOURCE_TO_CONCEPT_MAP 表中

If there is no source_concept_id available because the source codes are local and not supported by the Standard Vocabulary, the content of the field is 0 (zero, not null) encoding an undefined concept. However, local Source Concepts are established (concept_id values above 2,000,000,000).

这句话是什么意思

[wanghaisheng]

COHORT_DEFINITION table cohort_definition_id A unique identifier for each Cohort. 应该是A unique identifier for each Cohort definition

Note that the Domain is not codified using the alphanumerical domain_id like in the CONCEPT table. Instead, the corresponding Concept is used. The Concepts for each domain can be obtained from the DOMAIN table in the domain_concept_id

这里的备注是什么意思

[wanghaisheng]

can be defined as the amount of time between the cohort_start_date of the COHORT table and the year_of_birth, month_of_birth and day_of_birth of the PERSON table. Thus, such a Attribute Definition can be applied and instantiated with any Cohort, as long as it is applied to a Cohort of the same Domain (Person in this case), as it is defined in the subject_concept_id in the COHORT_DEFINITION table.

[wanghaisheng]

observation_period_start_date
The start date of the observation period for which data are available from the data source