Schema reference / Tables / view MDX source

lenke_classification

A system for classification of adolescent idiopathic scoliosis.

Purpose. To record the results for each component parameter and the classification for the Lenke classification system.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.lenke_classification.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.	—
`curve_type` `curve_type_code` `curve_type_system` `curve_type_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Curve type	`/data[at0001]/events[at0002]/data[at0003]/items[at0004]`
`lumbar_spine_modifier` `lumbar_spine_modifier_code` `lumbar_spine_modifier_system` `lumbar_spine_modifier_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Lumbar spine modifier	`/data[at0001]/events[at0002]/data[at0003]/items[at0011]`
`thoracic_sagittal_modifier` `thoracic_sagittal_modifier_code` `thoracic_sagittal_modifier_system` `thoracic_sagittal_modifier_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Thoracic sagittal modifier	`/data[at0001]/events[at0002]/data[at0003]/items[at0015]`
`classification` `classification_code` `classification_system` `classification_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Classification	`/data[at0001]/events[at0002]/data[at0003]/items[at0019]`

Constraints

check ((curve_type_code is null and curve_type_system is null and curve_type_valueset_id is null and curve_type is null) or (curve_type is not null and curve_type_code is not null and curve_type_system is not null and curve_type_valueset_id is not null))
check ((lumbar_spine_modifier_code is null and lumbar_spine_modifier_system is null and lumbar_spine_modifier_valueset_id is null and lumbar_spine_modifier is null) or (lumbar_spine_modifier is not null and lumbar_spine_modifier_code is not null and lumbar_spine_modifier_system is not null and lumbar_spine_modifier_valueset_id is not null))
check ((thoracic_sagittal_modifier_code is null and thoracic_sagittal_modifier_system is null and thoracic_sagittal_modifier_valueset_id is null and thoracic_sagittal_modifier is null) or (thoracic_sagittal_modifier is not null and thoracic_sagittal_modifier_code is not null and thoracic_sagittal_modifier_system is not null and thoracic_sagittal_modifier_valueset_id is not null))
check ((classification_code is null and classification_system is null and classification_valueset_id is null) or (classification is not null and classification_code is not null and classification_system is not null and classification_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
`curve_type_valueset_id, curve_type_code, curve_type_system, curve_type`	`valueset_code`	restrict
`lumbar_spine_modifier_valueset_id, lumbar_spine_modifier_code, lumbar_spine_modifier_system, lumbar_spine_modifier`	`valueset_code`	restrict
`thoracic_sagittal_modifier_valueset_id, thoracic_sagittal_modifier_code, thoracic_sagittal_modifier_system, thoracic_sagittal_modifier`	`valueset_code`	restrict
`classification_valueset_id, classification_code, classification_system, classification`	`valueset_code`	restrict

Indexes

lenke_classification_form_id_idx on form_id

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-OBSERVATION.lenke_classification.v1/curve_type`	6
`org.openehr::openEHR-EHR-OBSERVATION.lenke_classification.v1/lumbar_spine_modifier`	3
`org.openehr::openEHR-EHR-OBSERVATION.lenke_classification.v1/thoracic_sagittal_modifier`	3