OMOP_5.4_ER_ALL

OMOP_5.4_ER : Model

Entity - cohort_definition link

Properties
Name Value
Description

RESULT SCHEMA TABLE

Data Model Physical
Primary Key Clustered Unspecified
Unlogged false

Columns Summary
Column Name Data Type PK / FK Nullable Description
cohort_definition_id int4 PK / FK No
cohort_definition_name varchar(255) No
cohort_definition_description text Yes
definition_type_concept_id int4 FK No
cohort_definition_syntax text Yes
subject_concept_id int4 FK No
cohort_initiation_date date Yes

Relationships Summary
Name Begin End
 fpk_cohort_definition_cohort_definition_id : Relationship
 cohort : Entity
 cohort_definition : Entity
 fpk_cohort_definition_definition_type_concept_id : Relationship
 concept : Entity
 cohort_definition : Entity
 fpk_cohort_definition_subject_concept_id : Relationship
 concept : Entity
 cohort_definition : Entity

Columns Detail
Name Value
Name cohort_definition_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 cohort_definition_name
Type varchar
Nullable false
Unique false
Primary Key false
Index false
Type Name varchar
Length 255
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

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

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

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

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

Relationships Detail
Name Value
Name fpk_cohort_definition_cohort_definition_id
Foreign Key
cohort_definition
 cohort_definition_id : Column
Primary Key
cohort
 cohort_definition_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_cohort_definition_definition_type_concept_id
Foreign Key
cohort_definition
 definition_type_concept_id : 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_cohort_definition_subject_concept_id
Foreign Key
cohort_definition
 subject_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
OMOP_5.4_ER_ALL