Table postgres.omop.relationship
[VOCABULARY] The RELATIONSHIP table provides a reference list of all types of relationships that can be used to associate any two concepts in the CONCEPT_RELATIONSHP table.

 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
relationship_id varchar 20
concept_relationship.relationship_id fpk_concept_relationship_id R
relationship.reverse_relationship_id fpk_relationship_reverse R
The type of relationship captured by the relationship record.
relationship_name varchar 255 The text that describes the relationship type.
is_hierarchical varchar 1 Defines whether a relationship defines concepts into classes or hierarchies. Values are 1 for hierarchical relationship or 0 if not.
defines_ancestry varchar 1 Defines whether a hierarchical relationship contributes to the concept_ancestor table. These are subsets of the hierarchical relationships. Valid values are 1 or 0.
reverse_relationship_id varchar 20
relationship.relationship_id fpk_relationship_reverse R
The identifier for the relationship used to define the reverse relationship between two concepts.
relationship_concept_id int4 10
concept.concept_id fpk_relationship_concept R
A foreign key that refers to an identifier in the CONCEPT table for the unique relationship concept.

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

Indexes:
Column(s) Type Sort Constraint Name
relationship_id Primary key Asc xpk_relationship
relationship_id Must be unique Asc idx_relationship_rel_id

Close relationships  within of separation: