Activity #4208
closedModule #3537: Design
Module #4206: Custom Measurement & Analysis Wizard – UI and Database Design
Configure backend with measurements for Down's
100%
Description
If 9 measurements in Down’s analysis correspond to the ANGLE_LINES type (type_id = 1), pls prepare 9 INSERT statements by updating the landmark points specific to each measurement (e.g., Facial Angle, Angle of Convexity, A–B Plane Angle, etc.).
INSERT INTO ceph.measurements (name, type_id, args_json, unit, reference_title, reference_caption, meaning_small, meaning_normal, meaning_large)
VALUES (
'Facial Angle',
1,
'{
"args":[
{"name":"A","kind":"point","lm_point":"N","lm_id":34},
{"name":"B","kind":"point","lm_point":"Pog","lm_id":10},
{"name":"C","kind":"point","lm_point":"Po","lm_id":6},
{"name":"D","kind":"point","lm_point":"Or","lm_id":5}
]
}',
'deg',
'Facial Angle',
'Angle between N–Pog and Po–Or',
'Retrusive maxilla/mandible',
'Skeletal Class I',
'Protrusive maxilla/mandible'
);
INSERT INTO ceph.measurements (name, type_id, args_json, unit, reference_title, reference_caption, meaning_small, meaning_normal, meaning_large)
VALUES (
'Angle of Convexity',
1,
'{
"args":[
{"name":"A","kind":"point","lm_point":"N","lm_id":34},
{"name":"B","kind":"point","lm_point":"Pog","lm_id":10},
{"name":"C","kind":"point","lm_point":"Po","lm_id":6},
{"name":"D","kind":"point","lm_point":"Or","lm_id":5}
]
}',
'deg',
'Angle of Convexity',
'Angle between N–Pog and Po–Or',
'Retrusive maxilla/mandible',
'Skeletal Class I',
'Protrusive maxilla/mandible'
);
The fields meaning_small, meaning_normal, meaning_large can be populated by using a GenAI tool by giving prompts such as
Prepare for text in less than 10 words separately as the clinical meaning of small, normal, large value of Angle of Convexity in Down's analysis