Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| artefact_shape_id | INT UNSIGNED | 10 | √ | null |
|
|
||||
| artefact_id | INT UNSIGNED | 10 | 0 |
|
|
The id of the artefact to which this shape belongs. |
||||
| sqe_image_id | INT UNSIGNED | 10 | √ | NULL |
|
|
This points to the master image (see SQE_image table) in which this artefact is found. |
|||
| region_in_sqe_image | GEOMETRY | 0 | null |
|
|
This is the exact polygon of the artefact’s location within the master image’s coordinate system, but alwaya at a resolution of 1215 PPI. If the master image is not 1215 PPI it should be scaled to that resolution before the srtefact is drawn upon it. |
||||
| region_in_sqe_image_hash | BINARY | 128 | √ | NULL |
|
|
This is a quick hash of the region_in_sqe_image polygon for the purpose of uniqueness constraints. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | artefact_shape_id |
| fk_artefact_shape_to_artefact | Performance | Asc | artefact_id |
| fk_artefact_shape_to_sqe_image_idx | Performance | Asc | sqe_image_id |
| unique_artefact_shape | Must be unique | Asc/Asc/Asc | artefact_id + sqe_image_id + region_in_sqe_image_hash |