Table postgres.omop.concept_synonym
[VOCABULARY] The CONCEPT_SYNONYM table is used to store alternate names and descriptions for Concepts.

 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
concept_id int4 10
concept.concept_id fpk_concept_synonym_concept R
A foreign key to the Concept in the CONCEPT table.
concept_synonym_name varchar 1000 The alternative name for the Concept.
language_concept_id int4 10 A foreign key to a Concept representing the language.

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

Indexes:
Column(s) Type Sort Constraint Name
concept_id Performance Asc idx_concept_synonym_id

Close relationships  within of separation: