Table postgres.omop.vocabulary
[VOCABULARY] The VOCABULARY table includes a list of the Vocabularies collected from various sources or created de novo by the OMOP community. 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.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
vocabulary_id varchar 20
concept.vocabulary_id fpk_concept_vocabulary R
source_to_concept_map.source_vocabulary_id fpk_source_to_concept_map_v_1 R
source_to_concept_map.target_vocabulary_id fpk_source_to_concept_map_v_2 R
A unique identifier for each Vocabulary, such as ICD9CM, SNOMED, Visit.
vocabulary_name varchar 255 The name describing the vocabulary, for example "International Classification of Diseases, Ninth Revision, Clinical Modification, Volume 1 and 2 (NCHS)" etc.
vocabulary_reference varchar 255  √  null External reference to documentation or available download of the about the vocabulary.
vocabulary_version varchar 255  √  null Version of the Vocabulary as indicated in the source.
vocabulary_concept_id int4 10
concept.concept_id fpk_vocabulary_concept R
A foreign key that refers to a standard concept identifier in the CONCEPT table for the Vocabulary the VOCABULARY record belongs to.

Table contained 0 rows at dim. sept. 10 20:08 CEST 2017

Indexes:
Column(s) Type Sort Constraint Name
vocabulary_id Primary key Asc xpk_vocabulary
vocabulary_id Must be unique Asc idx_vocabulary_vocabulary_id

Close relationships  within of separation: