OMOP_5.4_ER_ALL

OMOP_5.4_ER : Model

Entity - fact_relationship link

Properties
Name Value
Description

 

FACT_RELATIONSHIP

Table Description

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, 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).

ETL Conventions

All relationships are directional, and each relationship is represented twice symmetrically within the FACT_RELATIONSHIP table. For example, two persons if person_id = 1 is the mother of person_id = 2 two records are in the FACT_RELATIONSHIP table (all strings in fact concept_id records in the Concept table: - Person, 1, Person, 2, parent of - Person, 2, Person, 1, child of

CDM Field User Guide ETL Conventions Datatype Required Primary Key Foreign Key FK Table FK Domain
domain_concept_id_1 integer Yes No Yes CONCEPT
fact_id_1 integer Yes No No
domain_concept_id_2 integer Yes No Yes CONCEPT
fact_id_2 integer Yes No No
relationship_concept_id integer Yes No Yes CONCEPT

Data Model Physical
Primary Key Clustered Unspecified
Unlogged false

Columns Summary
Column Name Data Type PK / FK Nullable Description
domain_concept_id_1 int4 PK / FK No
domain_concept_id_2 int4 PK / FK No
relationship_concept_id int4 PK / FK No
fact_id_1 int4 No
fact_id_2 int4 No

Relationships Summary
Name Begin End
 fpk_fact_relationship_domain_concept_id_1 : Relationship
 concept : Entity
 fact_relationship : Entity
 fpk_fact_relationship_domain_concept_id_2 : Relationship
 concept : Entity
 fact_relationship : Entity
 fpk_fact_relationship_relationship_concept_id : Relationship
 concept : Entity
 fact_relationship : Entity

Columns Detail
Name Value
Name domain_concept_id_1
Type int4
Nullable false
Unique false
Primary Key true
Index false
Length 0
Scale 0
Id Generator native
Foreign Key true
Generated Unspecified
Sync To Attribute Yes

Name Value
Name domain_concept_id_2
Type int4
Nullable false
Unique false
Primary Key true
Index false
Length 0
Scale 0
Id Generator native
Foreign Key true
Generated Unspecified
Sync To Attribute Yes

Name Value
Name relationship_concept_id
Type int4
Nullable false
Unique false
Primary Key true
Index false
Length 0
Scale 0
Id Generator native
Foreign Key true
Generated Unspecified
Sync To Attribute Yes

Name Value
Name fact_id_1
Type int4
Nullable false
Unique false
Primary Key false
Index false
Length 0
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name fact_id_2
Type int4
Nullable false
Unique false
Primary Key false
Index false
Length 0
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Relationships Detail
Name Value
Name fpk_fact_relationship_domain_concept_id_1
Foreign Key
fact_relationship
 domain_concept_id_1 : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_fact_relationship_domain_concept_id_2
Foreign Key
fact_relationship
 domain_concept_id_2 : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_fact_relationship_relationship_concept_id
Foreign Key
fact_relationship
 relationship_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Appears In
Diagram
 Standardized_Tables : Entity Relationship Diagram
 Vocabulary_With_Standard : Entity Relationship Diagram
OMOP_5.4_ER_ALL