death_summary

Summary information about the circumstances and context of the death of an individual, excluding the cause(s) of death.

Summary information about the circumstances and context of the death of an individual, excluding the cause(s) of death.

Purpose. To record summary information about the circumstances and context of the death of an individual, excluding the cause(s) of death.

Source

Columns

Constraints

check ((manner_of_death_code is null and manner_of_death_system is null and manner_of_death_valueset_id is null) or (manner_of_death is not null and manner_of_death_code is not null and manner_of_death_system is not null and manner_of_death_valueset_id is not null))
check ((place_category_code is null and place_category_system is null and place_category_valueset_id is null) or (place_category is not null and place_category_code is not null and place_category_system is not null and place_category_valueset_id is not null))
check ((place_of_injury_code is null and place_of_injury_system is null and place_of_injury_valueset_id is null) or (place_of_injury is not null and place_of_injury_code is not null and place_of_injury_system is not null and place_of_injury_valueset_id is not null))
check ((activity_at_the_time_of_injury_code is null and activity_at_the_time_of_injury_system is null and activity_at_the_time_of_injury_valueset_id is null) or (activity_at_the_time_of_injury is not null and activity_at_the_time_of_injury_code is not null and activity_at_the_time_of_injury_system is not null and activity_at_the_time_of_injury_valueset_id is not null))
check ((pregnancy_context_code is null and pregnancy_context_system is null and pregnancy_context_valueset_id is null) or (pregnancy_context is not null and pregnancy_context_code is not null and pregnancy_context_system is not null and pregnancy_context_valueset_id is not null))
check ((stillbirth_context_code is null and stillbirth_context_system is null and stillbirth_context_valueset_id is null) or (stillbirth_context is not null and stillbirth_context_code is not null and stillbirth_context_system is not null and stillbirth_context_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• death_summary_structured_place_of_death via death_summary_id

Indexes

• death_summary_form_id_idx on form_id

Child tables

1 table hang off death_summary, one row per repetition.

death_summary_structured_place_of_death

Child table — one row per repetition, deleted with its parent.

Unique

• death_summary_id, position
• death_summary_id, organization_id

References

Indexes

• death_summary_structured_place_of_death_organization_id_idx on organization_id

Value sets