Schema reference / Tables / view MDX source
acvpu
Simple scale used as part of an assessment to measure and record an individual's level of consciousness.
Simple scale used as part of an assessment to measure and record an individual's level of consciousness.
Purpose. To record an individual's level of consciousness.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-OBSERVATION.acvpu.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. | — |
acvpuacvpu_codeacvpu_systemacvpu_valueset_id | coded texttext, text, text, text | yes | ACVPU | /data[at0001]/events[at0002]/data[at0003]/items[at0004] |
Constraints
check ((acvpu_code is null and acvpu_system is null and acvpu_valueset_id is null and acvpu is null) or (acvpu is not null and acvpu_code is not null and acvpu_system is not null and acvpu_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 |
acvpu_valueset_id, acvpu_code, acvpu_system, acvpu | valueset_code | restrict |
Indexes
acvpu_form_id_idxonform_id
Value sets
| Value set | Codes |
|---|---|
org.openehr::openEHR-EHR-OBSERVATION.acvpu.v1/acvpu | 5 |