CollectionObjectType and Collection many-to-one on both sides

[lexiclevenger]

Describe the bug
The CollectionObjectType > Collection and Collection > CollectionObjectType relationships are both many-to-one.

To Reproduce
Steps to reproduce the behavior:

1. Go to User Tools
2. Go to Database Schema
3. Click Collection and see that the collectionObjectType relationship is many-to-one.
4. Click CollectionObjectType and see that the Collection relationship is many-to-one.

Expected behavior
CollectionObjectType > Collection should be many-to-one; Collection > CollectionObjectType should be one-to-many

Screenshots
Collection > COT:

COT > Collection:

COT > Collection query:

Collection > COT query:

Specify 7 System Information - 2025-01-30T20_19_56.588Z.txt

Please fill out the following information manually:

• OS: Mac
• Browser: Chrome
• Specify 7 Version: production
• Database Name: geo_2024_12_05_1_production
• Collection name: Geology
• User Name: Spadmin
• URL: https://geo202412051production-production.test.specifysystems.org/specify/data-model/#collectionobjecttype

[acwhite211]

In the Django model we have:

In Collection, we have a many-to-one foreign key to CollectionObjectType

specify7/specifyweb/specify/models.py

Line 1370 in 8f3b3fb

collectionobjecttype = models.ForeignKey('CollectionObjectType', db_column='CollectionObjectTypeID', related_name='collections', null=True, on_delete=models.SET_NULL)

In CollectionObjectType, we have a many-to-one foreign key to Collection

specify7/specifyweb/specify/models.py

Line 7511 in 8f3b3fb

collection = models.ForeignKey('Collection', db_column='CollectionID', related_name='cotypes', null=False, on_delete=protect_with_blockers)

In the datamodel we have:

In Collection, we have a many-to-one relationship to CollectionObjectType

specify7/specifyweb/specify/datamodel.py

Line 1478 in 8f3b3fb

Relationship(name='collectionObjectType', type='many-to-one',required=False, relatedModelName='CollectionObjectType', column='CollectionObjectTypeID', otherSideName='collections')

In CollectionObjectType, we have a many-to-one relationship to Collection

specify7/specifyweb/specify/datamodel.py

Line 8256 in 8f3b3fb

Relationship(name='collection', type='many-to-one', required=True, relatedModelName='Collection', column='CollectionID'),

So currently, each table has a foreign key the points to the other. The Django model and datamodel are in alignment.