Actions
Bug #3006
openAdd LSID+GUID to data rows
Start date:
11/16/2007
Due date:
% Done:
0%
Estimated time:
Bugzilla-Id:
3006
Description
The best way of tracking duplicates is unfortunately not our current system, but rather a GUID that is an LSID that has a GUID in it:
format: urn:lsid:cvs.bio.unc.edu:[tableName]:PK-[GUID]
length should be at least 150, probably go to full 255.
This would have to be override-able as sometimes newly created entities should map onto existing ones. This would enable each client entry tool to create unique IDs for data- without the need to update each client after adding to archive db.
This is far better than our current PK+bln_new flag. It would be a new series of fields (or one table?) that would create GUIDs and assign them to entities.
Actions