Project

General

Profile

Actions

Bug #3006

open

Add LSID+GUID to data rows

Added by Michael Lee about 17 years ago. Updated about 16 years ago.

Status:
New
Priority:
Normal
Assignee:
Category:
EntryDB
Target version:
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

Also available in: Atom PDF