Schema reference / Tables / view MDX source

simplified_tanner_whitehouse_3

A classification for the skeletal maturity stage in children, based on radiological assessment of the hand and wrist.

Purpose. To record the simplified Tanner-Whitehouse III skeletal maturity assessment.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.simplified_tanner_whitehouse_3.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.	—
`stage` `stage_code` `stage_system` `stage_numeric` `stage_valueset_id`	coded text `text`, `text`, `text`, `numeric`, `text`	yes	Stage	`/data[at0001]/events[at0002]/data[at0003]/items[at0004]`

Constraints

check ((stage_code is null and stage_system is null and stage_numeric is null and stage is null) or (stage_valueset_id is not null and stage_code is not null and stage_system is not null and stage_numeric is not null and stage is not null))

Unique

form_block_id

References

Columns	Target	On delete
`form_id`	`form`	cascade
`form_id, form_block_id`	`form_block`	cascade
`stage_valueset_id, stage_code, stage_system, stage, stage_numeric`	`valueset_code`	restrict

Indexes

simplified_tanner_whitehouse_3_form_id_idx on form_id

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-OBSERVATION.simplified_tanner_whitehouse_3.v1/stage`	8