0 rows


This table links a sign_interpretation to the ROI or ROIs it describes.


Column Type Size Nulls Auto Default Children Parents Comments
sign_interpretation_roi_id INT UNSIGNED 10 null
sign_interpretation_roi_owner.sign_interpretation_roi_id fk_sign_area_owner_to_sign_areaR
sign_interpretation_id INT UNSIGNED 10 NULL
sign_interpretation.sign_interpretation_id fk_sign_sign_roi_to_sign_interpretationR

Id of the sign interpretation being marked in an artefact.

roi_shape_id INT UNSIGNED 10 null
roi_shape.roi_shape_id fk_sign_area_to_roi_shapeR

Id of the shape for this ROI.

roi_position_id INT UNSIGNED 10 null
roi_position.roi_position_id fk_sign_area_to_roi_positionR

Id for the position of this ROI in its artefact.

values_set TINYINT UNSIGNED 3 0
exceptional TINYINT UNSIGNED 3 0

Boolean whether this ROI is exceptional (and thus should be excluded from some statistical analyses).


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc sign_interpretation_roi_id
fk_sign_area_to_area_idx Performance Asc roi_shape_id
fk_sign_area_to_area_position_idx Performance Asc roi_position_id
fk_sign_area_to_sign_interpretation_idx Performance Asc sign_interpretation_id
unique_sign_interpretation_shape_position Must be unique Asc/Asc/Asc sign_interpretation_id + roi_shape_id + roi_position_id