Class: Relationship¶

The RELATIONSHIP table provides a reference list of all types of relationships that can be used to associate any two Concepts in the CONCEPT_RELATIONSHIP table, the respective reverse relationships, and their hierarchical characteristics. Note, that Concepts representing relationships between the clinical facts, used for filling in the FACT_RELATIONSHIP table are stored in the CONCEPT table and belong to the Relationship Domain.

URI: https://athena.ohdsi.org/search-terms/terms#concept/Relationship

         classDiagram
    class Relationship
    click Relationship href "../Relationship/"
      Relationship : defines_ancestry
        
      Relationship : is_hierarchical
        
      Relationship : relationship_concept_id
        
          
    
        
        
        Relationship --> "1" Concept : relationship_concept_id
        click Concept href "../Concept/"
    

        
      Relationship : relationship_id
        
      Relationship : relationship_name
        
      Relationship : reverse_relationship_id
        
          
    
        
        
        Relationship --> "1" Relationship : reverse_relationship_id
        click Relationship href "../Relationship/"

Slots¶

Name	Cardinality and Range	Inheritance
relationship_id	1 String	direct
relationship_name	1 String	direct
is_hierarchical	1 Integer	direct
defines_ancestry	1 Integer	direct
reverse_relationship_id	1 Relationship	direct
relationship_concept_id	1 Concept	direct

Usages¶

used by	used in	type	used
Relationship	reverse_relationship_id	range	Relationship

Identifier and Mapping Information¶

Schema Source¶

from schema: https://athena.ohdsi.org/search-terms/terms#concept

Mappings¶

Mapping Type	Mapped Value
self	https://athena.ohdsi.org/search-terms/terms#concept/Relationship
native	https://athena.ohdsi.org/search-terms/terms#concept/Relationship

LinkML Source¶

Direct¶

```yaml name: Relationship description: The RELATIONSHIP table provides a reference list of all types of relationships that can be used to associate any two Concepts in the CONCEPT_RELATIONSHIP table, the respective reverse relationships, and their hierarchical characteristics. Note, that Concepts representing relationships between the clinical facts, used for filling in the FACT_RELATIONSHIP table are stored in the CONCEPT table and belong to the Relationship Domain. from_schema: https://athena.ohdsi.org/search-terms/terms#concept attributes: relationship_id: name: relationship_id from_schema: https://athena.ohdsi.org/search-terms/terms#concept rank: 1000 identifier: true domain_of: - Relationship range: string required: true relationship_name: name: relationship_name from_schema: https://athena.ohdsi.org/search-terms/terms#concept rank: 1000 domain_of: - Relationship range: string required: true is_hierarchical: name: is_hierarchical from_schema: https://athena.ohdsi.org/search-terms/terms#concept rank: 1000 domain_of: - Relationship range: integer required: true minimum_value: 0 maximum_value: 1 defines_ancestry: name: defines_ancestry from_schema: https://athena.ohdsi.org/search-terms/terms#concept rank: 1000 domain_of: - Relationship range: integer required: true minimum_value: 0 maximum_value: 1 reverse_relationship_id: name: reverse_relationship_id from_schema: https://athena.ohdsi.org/search-terms/terms#concept rank: 1000 domain_of: - Relationship range: Relationship required: true relationship_concept_id: name: relationship_concept_id from_schema: https://athena.ohdsi.org/search-terms/terms#concept rank: 1000 domain_of: - Relationship range: Concept required: true

</details>

### Induced

<details>
```yaml
name: Relationship
description: The RELATIONSHIP table provides a reference list of all types of relationships
  that can be used to associate any two Concepts in the CONCEPT_RELATIONSHIP table,
  the respective reverse relationships, and their hierarchical characteristics.  Note,
  that Concepts representing relationships between the clinical facts, used for filling
  in the FACT_RELATIONSHIP table are stored in the CONCEPT table and belong to the
  Relationship Domain.
from_schema: https://athena.ohdsi.org/search-terms/terms#concept
attributes:
  relationship_id:
    name: relationship_id
    from_schema: https://athena.ohdsi.org/search-terms/terms#concept
    rank: 1000
    identifier: true
    alias: relationship_id
    owner: Relationship
    domain_of:
    - Relationship
    range: string
    required: true
  relationship_name:
    name: relationship_name
    from_schema: https://athena.ohdsi.org/search-terms/terms#concept
    rank: 1000
    alias: relationship_name
    owner: Relationship
    domain_of:
    - Relationship
    range: string
    required: true
  is_hierarchical:
    name: is_hierarchical
    from_schema: https://athena.ohdsi.org/search-terms/terms#concept
    rank: 1000
    alias: is_hierarchical
    owner: Relationship
    domain_of:
    - Relationship
    range: integer
    required: true
    minimum_value: 0
    maximum_value: 1
  defines_ancestry:
    name: defines_ancestry
    from_schema: https://athena.ohdsi.org/search-terms/terms#concept
    rank: 1000
    alias: defines_ancestry
    owner: Relationship
    domain_of:
    - Relationship
    range: integer
    required: true
    minimum_value: 0
    maximum_value: 1
  reverse_relationship_id:
    name: reverse_relationship_id
    from_schema: https://athena.ohdsi.org/search-terms/terms#concept
    rank: 1000
    alias: reverse_relationship_id
    owner: Relationship
    domain_of:
    - Relationship
    range: Relationship
    required: true
  relationship_concept_id:
    name: relationship_concept_id
    from_schema: https://athena.ohdsi.org/search-terms/terms#concept
    rank: 1000
    alias: relationship_concept_id
    owner: Relationship
    domain_of:
    - Relationship
    range: Concept
    required: true