iaa_edition_catalog

38927 rows


Description

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

Columns

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.

Indexes

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

Relationships

Close relationships within degrees of separation