Schema reference / Tables / view MDX source

tanner

A scale to describe the onset and progression of pubertal changes.

Purpose. To describe progression of pubertal changes in genitals, breasts and pubic hair.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.tanner.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.	—
`genitals` `genitals_code` `genitals_system` `genitals_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Genitals	`/data[at0001]/events[at0002]/data[at0003]/items[at0004]`
`breasts` `breasts_code` `breasts_system` `breasts_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Breasts	`/data[at0001]/events[at0002]/data[at0003]/items[at0005]`
`pubic_hair` `pubic_hair_code` `pubic_hair_system` `pubic_hair_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Pubic hair	`/data[at0001]/events[at0002]/data[at0003]/items[at0006]`
`comment`	`text`	yes	Comment	`/data[at0001]/events[at0002]/data[at0003]/items[at0027]`

Constraints

check ((genitals_code is null and genitals_system is null and genitals_valueset_id is null and genitals is null) or (genitals is not null and genitals_code is not null and genitals_system is not null and genitals_valueset_id is not null))
check ((breasts_code is null and breasts_system is null and breasts_valueset_id is null and breasts is null) or (breasts is not null and breasts_code is not null and breasts_system is not null and breasts_valueset_id is not null))
check ((pubic_hair_code is null and pubic_hair_system is null and pubic_hair_valueset_id is null and pubic_hair is null) or (pubic_hair is not null and pubic_hair_code is not null and pubic_hair_system is not null and pubic_hair_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
`genitals_valueset_id, genitals_code, genitals_system, genitals`	`valueset_code`	restrict
`breasts_valueset_id, breasts_code, breasts_system, breasts`	`valueset_code`	restrict
`pubic_hair_valueset_id, pubic_hair_code, pubic_hair_system, pubic_hair`	`valueset_code`	restrict

Indexes

tanner_form_id_idx on form_id

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-OBSERVATION.tanner.v1/breasts`	5
`org.openehr::openEHR-EHR-OBSERVATION.tanner.v1/genitals`	5
`org.openehr::openEHR-EHR-OBSERVATION.tanner.v1/pubic_hair`	5