Table postgres.omop.death
[CLINICAL] The death domain contains the clinical event for how and when a Person dies. A person can have up to one record if the source system contains evidence about the Death, such as:

 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
person_id int4 10
person.person_id fpk_death_person R
A foreign key identifier to the deceased person. The demographic details of that person are stored in the person table.
death_date date 13 The date the person was deceased. If the precise date including day or month is not known or not allowed, December is used as the default month, and the last day of the month the default day.
death_datetime timestamp 29,6  √  null The date and time the person was deceased. If the precise date including day or month is not known or not allowed, December is used as the default month, and the last day of the month the default day.
death_type_concept_id int4 10
concept.concept_id fpk_death_type_concept R
A foreign key referring to the predefined concept identifier in the Standardized Vocabularies reflecting how the death was represented in the source data.
cause_concept_id int4 10  √  null
concept.concept_id fpk_death_cause_concept R
A foreign key referring to a standard concept identifier in the Standardized Vocabularies for conditions.
cause_source_value varchar 50  √  null The source code for the cause of death as it appears in the source data. This code is mapped to a standard concept in the Standardized Vocabularies and the original code is, stored here for reference.
cause_source_concept_id int4 10  √  null
concept.concept_id fpk_death_cause_concept_s R
A foreign key to the concept that refers to the code used in the source. Note, this variable name is abbreviated to ensure it will be allowable across database platforms.

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

Indexes:
Column(s) Type Sort Constraint Name
person_id Primary key Asc xpk_death
person_id Performance Asc idx_death_person_id

Close relationships  within of separation: