How are the Collection Attribute Table and the Collection Object table linked?

Get Help
8

Hi @Marion–

Thank you for your question! This is a quirk of how the data model is designed.

The table CollectionObject in the Specify database has a field known as CollectionObjectAttributeID which captures the identifier for the CollectionObjectAttribute record linked to it. Theoretically, a single CollectionObjectAttribute could be linked to multiple CollectionObject records thanks to this database design.

This technically gives CollectionObjectAttribute a one-to-many relationship to CollectionObject, but each CollectionObject has a one-to-one relationship to CollectionObjectAttribute.

TL;DR: A single CollectionObject can only have one CollectionObjectAttribute