Schema reference / Tables / view MDX source

hand_dominance

Hand dominance is an individual's natural preference for a specific hand for performing various motor tasks.

Purpose. To record an individual's natural preference for using a specific hand for various motor tasks.

Source

Model	Leg	Role
`openEHR-EHR-EVALUATION.hand_dominance.v0`	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.	—
`dominant_hand` `dominant_hand_code` `dominant_hand_system` `dominant_hand_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Dominant hand	`/data[at0001]/items[at0002]`
`comment`	`text`	yes	Comment	`/data[at0001]/items[at0013]`
`assessment_method`	`text`	yes	Assessment method	`/protocol[at0014]/items[at0016]`
`last_updated`	`timestamptz`	yes	Last updated	`/protocol[at0014]/items[at0023]`

Constraints

check ((dominant_hand_code is null and dominant_hand_system is null and dominant_hand_valueset_id is null) or (dominant_hand is not null and dominant_hand_code is not null and dominant_hand_system is not null and dominant_hand_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
`dominant_hand_valueset_id, dominant_hand_code, dominant_hand_system, dominant_hand`	`valueset_code`	restrict

Indexes

hand_dominance_form_id_idx on form_id

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-EVALUATION.hand_dominance.v0/dominant_hand`	4