Table postgres.omop.fact_relationship
[CLINICAL] The FACT_RELATIONSHIP table contains records about the relationships between facts stored as records in any table of the CDM. Relationships can be defined between facts from the same domain (table), or different domains. Examples of Fact Relationships include: Person relationships (parent-child), care site relationships (hierarchical organizational structure of facilities within a health system), indication relationship (between drug exposures and associated conditions), usage relationships (of devices during the course of an associated procedure), or facts derived from one another (measurements derived from an associated specimen).

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
domain_concept_id_1 int4 10
concept.concept_id fpk_fact_domain_1 R
The concept representing the domain of fact one, from which the corresponding table can be inferred.
fact_id_1 int4 10 The unique identifier in the table corresponding to the domain of fact one.
domain_concept_id_2 int4 10
concept.concept_id fpk_fact_domain_2 R
The concept representing the domain of fact two, from which the corresponding table can be inferred.
fact_id_2 int4 10 The unique identifier in the table corresponding to the domain of fact two.
relationship_concept_id int4 10
concept.concept_id fpk_fact_relationship R
A foreign key to a Standard Concept ID of relationship in the Standardized Vocabularies.

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

Indexes:
Column(s) Type Sort Constraint Name
domain_concept_id_1 Performance Asc idx_fact_relationship_id_1
domain_concept_id_2 Performance Asc idx_fact_relationship_id_2
relationship_concept_id Performance Asc idx_fact_relationship_id_3

Close relationships  within of separation: