hirsutism_scales

A grouping of related assessment scales used to quantify distribution and growth of body hair in women.

A grouping of related assessment scales used to quantify distribution and growth of body hair in women.

Purpose. To record hair scores for up to thirteen body areas and a total sum of scores, in order to quantify excessive male-pattern hair growth in women.

Source

ModelLegRole
openEHR-EHR-OBSERVATION.hirsutism_scales.v1openEHRdefines this table

Columns

ColumnTypeNullDescriptionSource
iduuid primary keynoPrimary key.
form_iduuidformnoThe form this entry was recorded on.
form_block_iduuidyesThe block within the form, when the entry is bound to one.
upper_lip_hair
upper_lip_hair_code
upper_lip_hair_system
upper_lip_hair_numeric
upper_lip_hair_valueset_id
coded text
text, text, text, numeric, text
yesUpper lip hair/data[at0001]/events[at0002]/data[at0003]/items[at0005]
chin_hair
chin_hair_code
chin_hair_system
chin_hair_numeric
chin_hair_valueset_id
coded text
text, text, text, numeric, text
yesChin hair/data[at0001]/events[at0002]/data[at0003]/items[at0019]
sideburn_hair
sideburn_hair_code
sideburn_hair_system
sideburn_hair_numeric
sideburn_hair_valueset_id
coded text
text, text, text, numeric, text
yesSideburn hair/data[at0001]/events[at0002]/data[at0003]/items[at0082]
chest_hair
chest_hair_code
chest_hair_system
chest_hair_numeric
chest_hair_valueset_id
coded text
text, text, text, numeric, text
yesChest hair/data[at0001]/events[at0002]/data[at0003]/items[at0025]
upper_back_hair
upper_back_hair_code
upper_back_hair_system
upper_back_hair_numeric
upper_back_hair_valueset_id
coded text
text, text, text, numeric, text
yesUpper back hair/data[at0001]/events[at0002]/data[at0003]/items[at0031]
lower_back_hair
lower_back_hair_code
lower_back_hair_system
lower_back_hair_numeric
lower_back_hair_valueset_id
coded text
text, text, text, numeric, text
yesLower back hair/data[at0001]/events[at0002]/data[at0003]/items[at0037]
upper_abdomen_hair
upper_abdomen_hair_code
upper_abdomen_hair_system
upper_abdomen_hair_numeric
upper_abdomen_hair_valueset_id
coded text
text, text, text, numeric, text
yesUpper abdomen hair/data[at0001]/events[at0002]/data[at0003]/items[at0043]
lower_abdomen_hair
lower_abdomen_hair_code
lower_abdomen_hair_system
lower_abdomen_hair_numeric
lower_abdomen_hair_valueset_id
coded text
text, text, text, numeric, text
yesLower abdomen hair/data[at0001]/events[at0002]/data[at0003]/items[at0049]
upper_arm_hair
upper_arm_hair_code
upper_arm_hair_system
upper_arm_hair_numeric
upper_arm_hair_valueset_id
coded text
text, text, text, numeric, text
yesUpper arm hair/data[at0001]/events[at0002]/data[at0003]/items[at0055]
lower_arm_hair
lower_arm_hair_code
lower_arm_hair_system
lower_arm_hair_numeric
lower_arm_hair_valueset_id
coded text
text, text, text, numeric, text
yesLower arm hair/data[at0001]/events[at0002]/data[at0003]/items[at0061]
thigh_hair
thigh_hair_code
thigh_hair_system
thigh_hair_numeric
thigh_hair_valueset_id
coded text
text, text, text, numeric, text
yesThigh hair/data[at0001]/events[at0002]/data[at0003]/items[at0067]
lower_leg_hair
lower_leg_hair_code
lower_leg_hair_system
lower_leg_hair_numeric
lower_leg_hair_valueset_id
coded text
text, text, text, numeric, text
yesLower leg hair/data[at0001]/events[at0002]/data[at0003]/items[at0073]
perineum_hair
perineum_hair_code
perineum_hair_system
perineum_hair_numeric
perineum_hair_valueset_id
coded text
text, text, text, numeric, text
yesPerineum hair/data[at0001]/events[at0002]/data[at0003]/items[at0091]
total_scoreintegeryesTotal score/data[at0001]/events[at0002]/data[at0003]/items[at0079]
ferriman_gallwey_scoreintegeryesFerriman-Gallwey score/data[at0001]/events[at0002]/data[at0003]/items[at0089]
modified_ferriman_gallwey_scoreintegeryesModified Ferriman-Gallwey score/data[at0001]/events[at0002]/data[at0003]/items[at0090]

Constraints

check ((upper_lip_hair_code is null and upper_lip_hair_system is null and upper_lip_hair_numeric is null and upper_lip_hair is null) or (upper_lip_hair_valueset_id is not null and upper_lip_hair_code is not null and upper_lip_hair_system is not null and upper_lip_hair_numeric is not null and upper_lip_hair is not null))
check ((chin_hair_code is null and chin_hair_system is null and chin_hair_numeric is null and chin_hair is null) or (chin_hair_valueset_id is not null and chin_hair_code is not null and chin_hair_system is not null and chin_hair_numeric is not null and chin_hair is not null))
check ((sideburn_hair_code is null and sideburn_hair_system is null and sideburn_hair_numeric is null and sideburn_hair is null) or (sideburn_hair_valueset_id is not null and sideburn_hair_code is not null and sideburn_hair_system is not null and sideburn_hair_numeric is not null and sideburn_hair is not null))
check ((chest_hair_code is null and chest_hair_system is null and chest_hair_numeric is null and chest_hair is null) or (chest_hair_valueset_id is not null and chest_hair_code is not null and chest_hair_system is not null and chest_hair_numeric is not null and chest_hair is not null))
check ((upper_back_hair_code is null and upper_back_hair_system is null and upper_back_hair_numeric is null and upper_back_hair is null) or (upper_back_hair_valueset_id is not null and upper_back_hair_code is not null and upper_back_hair_system is not null and upper_back_hair_numeric is not null and upper_back_hair is not null))
check ((lower_back_hair_code is null and lower_back_hair_system is null and lower_back_hair_numeric is null and lower_back_hair is null) or (lower_back_hair_valueset_id is not null and lower_back_hair_code is not null and lower_back_hair_system is not null and lower_back_hair_numeric is not null and lower_back_hair is not null))
check ((upper_abdomen_hair_code is null and upper_abdomen_hair_system is null and upper_abdomen_hair_numeric is null and upper_abdomen_hair is null) or (upper_abdomen_hair_valueset_id is not null and upper_abdomen_hair_code is not null and upper_abdomen_hair_system is not null and upper_abdomen_hair_numeric is not null and upper_abdomen_hair is not null))
check ((lower_abdomen_hair_code is null and lower_abdomen_hair_system is null and lower_abdomen_hair_numeric is null and lower_abdomen_hair is null) or (lower_abdomen_hair_valueset_id is not null and lower_abdomen_hair_code is not null and lower_abdomen_hair_system is not null and lower_abdomen_hair_numeric is not null and lower_abdomen_hair is not null))
check ((upper_arm_hair_code is null and upper_arm_hair_system is null and upper_arm_hair_numeric is null and upper_arm_hair is null) or (upper_arm_hair_valueset_id is not null and upper_arm_hair_code is not null and upper_arm_hair_system is not null and upper_arm_hair_numeric is not null and upper_arm_hair is not null))
check ((lower_arm_hair_code is null and lower_arm_hair_system is null and lower_arm_hair_numeric is null and lower_arm_hair is null) or (lower_arm_hair_valueset_id is not null and lower_arm_hair_code is not null and lower_arm_hair_system is not null and lower_arm_hair_numeric is not null and lower_arm_hair is not null))
check ((thigh_hair_code is null and thigh_hair_system is null and thigh_hair_numeric is null and thigh_hair is null) or (thigh_hair_valueset_id is not null and thigh_hair_code is not null and thigh_hair_system is not null and thigh_hair_numeric is not null and thigh_hair is not null))
check ((lower_leg_hair_code is null and lower_leg_hair_system is null and lower_leg_hair_numeric is null and lower_leg_hair is null) or (lower_leg_hair_valueset_id is not null and lower_leg_hair_code is not null and lower_leg_hair_system is not null and lower_leg_hair_numeric is not null and lower_leg_hair is not null))
check ((perineum_hair_code is null and perineum_hair_system is null and perineum_hair_numeric is null and perineum_hair is null) or (perineum_hair_valueset_id is not null and perineum_hair_code is not null and perineum_hair_system is not null and perineum_hair_numeric is not null and perineum_hair is not null))
check (total_score is null or total_score between 0 and 52)
check (ferriman_gallwey_score is null or ferriman_gallwey_score between 0 and 44)
check (modified_ferriman_gallwey_score is null or modified_ferriman_gallwey_score between 0 and 36)

Unique

References

ColumnsTargetOn delete
form_idformcascade
form_id, form_block_idform_blockcascade
upper_lip_hair_valueset_id, upper_lip_hair_code, upper_lip_hair_system, upper_lip_hair, upper_lip_hair_numericvalueset_coderestrict
chin_hair_valueset_id, chin_hair_code, chin_hair_system, chin_hair, chin_hair_numericvalueset_coderestrict
sideburn_hair_valueset_id, sideburn_hair_code, sideburn_hair_system, sideburn_hair, sideburn_hair_numericvalueset_coderestrict
chest_hair_valueset_id, chest_hair_code, chest_hair_system, chest_hair, chest_hair_numericvalueset_coderestrict
upper_back_hair_valueset_id, upper_back_hair_code, upper_back_hair_system, upper_back_hair, upper_back_hair_numericvalueset_coderestrict
lower_back_hair_valueset_id, lower_back_hair_code, lower_back_hair_system, lower_back_hair, lower_back_hair_numericvalueset_coderestrict
upper_abdomen_hair_valueset_id, upper_abdomen_hair_code, upper_abdomen_hair_system, upper_abdomen_hair, upper_abdomen_hair_numericvalueset_coderestrict
lower_abdomen_hair_valueset_id, lower_abdomen_hair_code, lower_abdomen_hair_system, lower_abdomen_hair, lower_abdomen_hair_numericvalueset_coderestrict
upper_arm_hair_valueset_id, upper_arm_hair_code, upper_arm_hair_system, upper_arm_hair, upper_arm_hair_numericvalueset_coderestrict
lower_arm_hair_valueset_id, lower_arm_hair_code, lower_arm_hair_system, lower_arm_hair, lower_arm_hair_numericvalueset_coderestrict
thigh_hair_valueset_id, thigh_hair_code, thigh_hair_system, thigh_hair, thigh_hair_numericvalueset_coderestrict
lower_leg_hair_valueset_id, lower_leg_hair_code, lower_leg_hair_system, lower_leg_hair, lower_leg_hair_numericvalueset_coderestrict
perineum_hair_valueset_id, perineum_hair_code, perineum_hair_system, perineum_hair, perineum_hair_numericvalueset_coderestrict

Indexes

Value sets

Value setCodes
org.openehr::openEHR-EHR-OBSERVATION.hirsutism_scales.v1/chest_hair5
org.openehr::openEHR-EHR-OBSERVATION.hirsutism_scales.v1/chin_hair5
org.openehr::openEHR-EHR-OBSERVATION.hirsutism_scales.v1/lower_abdomen_hair5
org.openehr::openEHR-EHR-OBSERVATION.hirsutism_scales.v1/lower_arm_hair5
org.openehr::openEHR-EHR-OBSERVATION.hirsutism_scales.v1/lower_back_hair5
org.openehr::openEHR-EHR-OBSERVATION.hirsutism_scales.v1/lower_leg_hair5
org.openehr::openEHR-EHR-OBSERVATION.hirsutism_scales.v1/perineum_hair5
org.openehr::openEHR-EHR-OBSERVATION.hirsutism_scales.v1/sideburn_hair5
org.openehr::openEHR-EHR-OBSERVATION.hirsutism_scales.v1/thigh_hair5
org.openehr::openEHR-EHR-OBSERVATION.hirsutism_scales.v1/upper_abdomen_hair5
org.openehr::openEHR-EHR-OBSERVATION.hirsutism_scales.v1/upper_arm_hair5
org.openehr::openEHR-EHR-OBSERVATION.hirsutism_scales.v1/upper_back_hair5
org.openehr::openEHR-EHR-OBSERVATION.hirsutism_scales.v1/upper_lip_hair5