gbif / model-tests

Exploration of sample models
2 stars 0 forks source link

I miss a link between host and parasite #21

Closed MortenHofft closed 2 years ago

MortenHofft commented 2 years ago

I'm looking at https://arctos.database.museum/guid/DMNS:Mamm:11098 and wonder how to recreate it. It would be nice to be able to link to the parasite. But I believe it isn't linked at the moment.

What I try to do is: go to the relationships table and lookup my entity 21714980 and find this

entityRelationshipID dependsOnEntityRelationshipID subjectEntityID entityRelationshipType objectEntityID externalObjectEntityID
1   21714980 host of   http://arctos.database.museum/guid/DMNS:Para:664
2   21714980 host of   http://arctos.database.museum/guid/DMNS:Para:64
3   21714980 host of   http://arctos.database.museum/guid/DMNS:Para:6

But the ObjectEntityID isn't filled.

I can go to the identifiers table and look up e.g.http://arctos.database.museum/guid/DMNS:Para:664 and get the entityID 26462265. But shouldn't it just be in relationships table to begin with?

tucotuco commented 2 years ago

Addressed by adding keys to objectedEntityID for objects with URIs in https://github.com/timrobertson100/model-tests/commit/7e68fb1614fbb6ddf8e9c265942f339a3a969478.