search

BU-Spark / se-Symbiota-portal

The Symbiota Virtual Flora/Fauna project is an open source software project, with central goal of developing on-line tools that aid in the generation, exploration and management of biodiversity data (collection specimens, observations, images, checklist, keys, etc.). See also: http://bdj.pensoft.net/articles.php?id=1114 and http://symbiota.org/
GNU General Public License v2.0
1 stars 3 forks source link

Conflict between the batch occId and universal occid #55

Closed ttaliacc closed 2 months ago

ttaliacc commented 11 months ago

The new quick entry form and quick entry form should have access to the same occurrence table, which means they share the same occurrence database. However, to display the occurrence within a batch and make it easier to navigate among the occurrences within the batch, we create a new "occId" when we open the occurrence in the quick entry form

In this way, a issue will occur when we are trying to create a new occurrence. Because we will need to generate a real occid in the omoccurrence table.

Another problem is that we use the feature "occurrenceID" to connect the image and omoccurrence table. If we create a new occurrence, how can we generate the value of this feature?

Related to

ttaliacc commented 11 months ago

There is a potential issue with using sequential occid as one of the keys. When ever we delete an occurrence, having a new occid as len(occ table)+1 will not be unique

Tian-Tan commented 10 months ago

After the meeting, the conclusion is to use sequential id for internal processes and use GUID for display purposes.

Tian-Tan commented 10 months ago

Will be keeping this issue open until the changes are implemented in the database and frontend