41950 rows


The referencing system of the institution providing the images.


Column Type Size Nulls Auto Default Children Parents Comments
image_catalog_id INT UNSIGNED 10 null
image_catalog_author.image_catalog_id fk_image_catalog_owner_to_image_catalog_idR
image_to_iaa_edition_catalog.image_catalog_id fk_to_catalog_idR
SQE_image.image_catalog_id fk_image_to_catalogR
institution VARCHAR 255 'NULL'

Name of the institution providing the image.

catalog_number_1 VARCHAR 255 'NULL'

First tier object identifier (perhaps a plate or accession number).

catalog_number_2 VARCHAR 255 'NULL'

Second tier object identifier (if available). Perhaps a fragment number on a plate, or some subdesignation of an accession number.

catalog_side BIT 3 0

Side reference designation, recto = 0, verso = 1.

object_id VARCHAR 255 NULL

An autogenerated human readable object identifier based on the institution and catalogue numbers.


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc image_catalog_id
unique_catalog_entry Must be unique Asc/Asc/Asc/Asc catalog_number_1 + catalog_number_2 + catalog_side + institution