image_to_iaa_edition_catalog

39105 rows


Description

Temporary table to link image catalog info with edition info until the SQE_image table is fully populated. Once that table is populated this one will become redundant. This was autogenerated from IAA data.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
iaa_edition_catalog_id INT UNSIGNED 10 0
iaa_edition_catalog.iaa_edition_catalog_id fk_to_edition_idR
image_catalog_id INT UNSIGNED 10 0
image_catalog.image_catalog_id fk_to_catalog_idR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc iaa_edition_catalog_id + image_catalog_id
fk_to_catalog_id Performance Asc image_catalog_id

Relationships