Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sqe_image_id | INT UNSIGNED | 10 | √ | null |
|
|
||||||||||
image_urls_id | INT UNSIGNED | 10 | 0 |
|
|
Link to image_urls table which contains the url of the iiif server that provides this image and the default suffix used to get images from that server. |
||||||||||
filename | VARCHAR | 255 | √ | 'NULL' |
|
|
Actual filename of the image as specified on the iiif server. This may often look more like a URI, or a partial URI. |
|||||||||
native_width | INT UNSIGNED | 10 | 0 |
|
|
We store internally the pixel width of the full size image. |
||||||||||
native_height | INT UNSIGNED | 10 | 0 |
|
|
We store internally the pixel height of the full size image. |
||||||||||
dpi | INT UNSIGNED | 10 | 0 |
|
|
The DPI of the full size image (used to calculate relative scaling of images). This should be calculated as optimally as possible and should not rely on EXIF data. |
||||||||||
type | BIT | 3 | 0 |
|
|
Four values: |
||||||||||
wavelength_start | SMALLINT UNSIGNED | 5 | 445 |
|
|
Starting wavelength of image in nanometers. |
||||||||||
wavelength_end | SMALLINT UNSIGNED | 5 | 704 |
|
|
Ending wavelength of image in nanometers. |
||||||||||
is_master | BIT | 3 | 0 |
|
|
Boolean determining if the image is a “master image”. Since we have multiple images of each fragment, one image is designated as the master (generally the full color image), all others are non master images and will have a corresponding entry in “image_to_image_map” which provides and transforms (translate, scale, rotate) necessary to line the two images up with each other. |
||||||||||
image_catalog_id | INT UNSIGNED | 10 | √ | 0 |
|
|
Id of the image in the image catalogue. |
|||||||||
is_recto | BIT | 3 | 1 |
|
|
Notes wether the original image is thought to show rect0 (1) or verso (0) of the fragment. This can be taken as default value for recto/verso-relation in artefact_stack |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | sqe_image_id |
fk_image_to_catalog | Performance | Asc | image_catalog_id |
url_UNIQUE | Must be unique | Asc/Asc | image_urls_id + filename |