image_catalog

41950 rows


Description

The referencing system of the institution providing the images.

Columns

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.

Indexes

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

Relationships

Close relationships within degrees of separation