38927 rows


This table contains the IAA data for the editio princeps reference for all of their images.


Column Type Size Nulls Auto Default Children Parents Comments
iaa_edition_catalog_id INT UNSIGNED 10 null
iaa_edition_catalog_author.iaa_edition_catalog_id fk_edition_catalog_owner_to_edition_catalog_idR
iaa_edition_catalog_to_text_fragment.iaa_edition_catalog_id fk_edition_catalog_to_text_fragment_to_edition_catalog_idR
image_to_iaa_edition_catalog.iaa_edition_catalog_id fk_to_edition_idR
manuscript VARCHAR 255 'NULL'

Standard designation of the manuscript.

edition_name VARCHAR 255 'NULL'

Name of the publication in which the editio princeps appears.

edition_volume VARCHAR 128 'NULL'

Volume of the publication in which the editio princeps appears.

edition_location_1 VARCHAR 64 'NULL'

First tier identifier (usually a page number).

edition_location_2 VARCHAR 64 'NULL'

Second tier identifier (usually a fragment/column designation).

edition_side BIT 3 0

Side designation in editio princeps.

manuscript_id INT UNSIGNED 10 NULL
manuscript.manuscript_id fk_edition_catalog_to_manuscript_idR

Id of the manuscript within the SQE database.

comment VARCHAR 255 NULL

Extra comments.


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc iaa_edition_catalog_id
fk_edition_catalog_to_manuscript_id Performance Asc manuscript_id
unique_edition_entry Must be unique Asc/Asc/Asc/Asc/Asc/Asc edition_location_1 + edition_location_2 + edition_name + edition_side + edition_volume + manuscript