Schema reference / Tables / view MDX source
age_assertion
A statement about the age of an individual at a point in time.
A statement about the age of an individual at a point in time.
Purpose. To record a statement about the age of an individual at a point in time, as clinical context for the other information in the same COMPOSITION.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-OBSERVATION.age_assertion.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. | — |
chronological_age | interval | yes | Chronological age | /data[at0001]/events[at0002]/data[at0003]/items[at0004] |
adjusted_age | interval | yes | Adjusted age | /data[at0001]/events[at0002]/data[at0003]/items[at0005] |
comment | text | yes | Comment | /data[at0001]/events[at0002]/data[at0003]/items[at0006] |
Unique
form_block_id
References
| Columns | Target | On delete |
|---|---|---|
form_id | form | cascade |
form_id, form_block_id | form_block | cascade |
Indexes
age_assertion_form_id_idxonform_id