Project

General

Profile

Task #361

create a table for the mapping between GUID and Localid in Metacat

Added by Matthew Jones almost 15 years ago. Updated almost 15 years ago.

Status:
Closed
Priority:
Low
Assignee:
Category:
Metacat
Target version:
Start date:
Due date:
% Done:

100%

Milestone:
None
Product Version:
*
Story Points:
Sprint:

Description

Need a table in Metacat that stores the mapping between Globally unique, arbitrary string identifiers and the LocalID that metacat uses internally for storing and tracking objects (referred to as a 'docid' in Metacat).

History

#1 Updated by Matthew Jones almost 15 years ago

Table created for postgres, need to duplicate for Oracle, and determine length of the guid column (currently too short at 250 characters).

#2 Updated by Matthew Jones almost 15 years ago

  • Status changed from New to Closed

Table 'identifier' now complete for postgres and oracle. In postgres, the guid uses the 'text' type to allow arbitrary length strings. In Oracle, the guid uses varchar2(2000), which should be more than adequate for even long URIs used as identifiers. Oracle changes made but untested.

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 14.8 MB)