Revision 5276
Added by Matt Jones about 14 years ago
| xmltables-postgres.sql | ||
|---|---|---|
| 270 | 270 |
|
| 271 | 271 |
/* |
| 272 | 272 |
* Table used to store all document identifiers in metacat. Each identifier |
| 273 |
* consists of 4 subparts, an authority, namespace, object, and revision as |
|
| 274 |
* defined in the LSID specification. |
|
| 273 |
* has a globally unique, unconstrained string, which we will refer to as a |
|
| 274 |
* GUID, and a local metacat identifier, which consists of the docid |
|
| 275 |
* and revision fields. Each row maps one global identifier to the local |
|
| 276 |
* identifier (docid) used within metacat. |
|
| 275 | 277 |
*/ |
| 276 |
CREATE SEQUENCE identifier_id_seq; |
|
| 277 | 278 |
CREATE TABLE identifier ( |
| 278 |
id INT8 default nextval('identifier_id_seq') PRIMARY KEY, -- primary id
|
|
| 279 |
authority VARCHAR(255), -- the authority issuing the identifier |
|
| 280 |
namespace VARCHAR(255), -- the namespace qualifying the identifier |
|
| 281 |
object VARCHAR(255), -- the local part of the identifier for a particular object |
|
| 282 |
revision VARCHAR(255) -- the revision part of the identifier |
|
| 279 |
guid text, -- the globally unique string identifier |
|
| 280 |
docid VARCHAR(250), -- the local document id # |
|
| 281 |
rev INT8, -- the revision part of the local identifier |
|
| 282 |
CONSTRAINT identifier_pk PRIMARY KEY (guid) |
|
| 283 | 283 |
); |
| 284 | 284 |
|
| 285 | 285 |
/* |
Also available in: Unified diff
Modified table structure to change identifiers table (previously unused) to
represent a mapping between arbitrary string identifiers and metacat docids.
More information in https://trac.dataone.org/ticket/361. Modifications to
Oracle schemas were made but not tested.