image_to_image_map

69272 rows


Description

This table contains the mapping information to correlate images of the same object via linear affine transformations. The mapping may only invlove a portion of either image as defined in the region_on_imageX columns.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
image_to_image_map_id INT UNSIGNED 10 √ null
image_to_image_map_author.image_to_image_map_id fk_image_to_image_map_author_to_image_to_image_mapR
point_to_point_map.image_to_image_map_id fK_p_to_p_toIm_to_imR
image1_id INT UNSIGNED 10 0
SQE_image.sqe_image_id fk_image1_to_image_idR

Id of the first SQE_image to be mapped.
image2_id INT UNSIGNED 10 0
SQE_image.sqe_image_id fk_image2_to_image_idR

Id of the second SQE_image to be mapped.
region_on_image1 POLYGON 0 null

Region on image 1 that can be found in image 2.
region_on_image2 POLYGON 0 null

Region in image 2 that can be found in image 1.
transform_matrix VARCHAR 255 '{"matrix":[[1,0,0],[0,1,0]]}'

Linear affine transform to apply to image 2 in order to align it with image 1. The format is: “{“matrix”: [[sx cosθ, -sy sinθ, tx],[sx sinθ, sy cosθ, ty]]}”.

[[sx cosθ, -sy sinθ, tx]: ./../null
[sx sinθ, sy cosθ, ty]: ./../null
region1_hash BINARY 128 √ NULL

θ
region2_hash BINARY 128 √ NULL

Polygon hash for uniqueness constraints.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc image_to_image_map_id
fk_image1_to_image_id Performance Asc image1_id
fk_image2_to_image_id Performance Asc image2_id
unique_image_to_image_map Must be unique Asc/Asc/Asc/Asc/Asc image1_id + image2_id + region1_hash + region2_hash + transform_matrix

Relationships

Close relationships within degrees of separation