Schema reference / Tables / view MDX source
nyha_heart_failure
A simple method of classifying the extent of heart failure, as defined by the New York Heart Association.
A simple method of classifying the extent of heart failure, as defined by the New York Heart Association.
Purpose. To record one or both of: - a functional assessment of heart failure based on symptoms; and - an objective assessment based on both evidence of cardiovascular disease and symptoms.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-OBSERVATION.nyha_heart_failure.v1 | openEHR | defines this table |
Columns
| Column | Type | Null | Description | Source |
|---|---|---|---|---|
id | uuid primary key | no | Primary key. | — |
form_id | uuid → form | no | The form this entry was recorded on. | — |
form_block_id | uuid | yes | The block within the form, when the entry is bound to one. | — |
functional_capacityfunctional_capacity_codefunctional_capacity_systemfunctional_capacity_valueset_id | coded texttext, text, text, text | yes | Functional capacity | /data[at0001]/events[at0002]/data[at0003]/items[at0004] |
objective_assessmentobjective_assessment_codeobjective_assessment_systemobjective_assessment_valueset_id | coded texttext, text, text, text | yes | Objective assessment | /data[at0001]/events[at0002]/data[at0003]/items[at0011] |
confounding_factors | text | yes | Confounding factors | /data[at0001]/events[at0002]/state[at0016]/items[at0017] |
Constraints
check ((functional_capacity_code is null and functional_capacity_system is null and functional_capacity_valueset_id is null and functional_capacity is null) or (functional_capacity is not null and functional_capacity_code is not null and functional_capacity_system is not null and functional_capacity_valueset_id is not null))
check ((objective_assessment_code is null and objective_assessment_system is null and objective_assessment_valueset_id is null and objective_assessment is null) or (objective_assessment is not null and objective_assessment_code is not null and objective_assessment_system is not null and objective_assessment_valueset_id is not null))Unique
form_block_id
References
| Columns | Target | On delete |
|---|---|---|
form_id | form | cascade |
form_id, form_block_id | form_block | cascade |
functional_capacity_valueset_id, functional_capacity_code, functional_capacity_system, functional_capacity | valueset_code | restrict |
objective_assessment_valueset_id, objective_assessment_code, objective_assessment_system, objective_assessment | valueset_code | restrict |
Indexes
nyha_heart_failure_form_id_idxonform_id
Value sets
| Value set | Codes |
|---|---|
org.openehr::openEHR-EHR-OBSERVATION.nyha_heart_failure.v1/functional_capacity | 6 |
org.openehr::openEHR-EHR-OBSERVATION.nyha_heart_failure.v1/objective_assessment | 4 |