Closed dthonon closed 2 years ago
In fact, created UUID are stored in import.uuid_xref
table. I am not sure this has been really used to transmit observations.
The pseudo_id_sighting
in observations table is an encoding of the sightings id
: encode(hmac(NEW.id::text, '{{ cfg.db_secret_key }}', 'sha1'), 'hex')
.
I propose to :
import.uuid_xref
, if unused. To be confirmed.pseudo_id_sighting
as the identifier that can be exported to other parties.mentioned in commit fd7f0774ab888ede5e1716d3e59846bbad8e4fe9
In GitLab by @fred.lpo07 on Apr 6, 2021, 00:12
Data UUIDs are now available in the faune-france API, they should be used preferably if available.
path:
item #>> '{observers,0,uuid}'