Project

General

Profile

« Previous | Next » 

Revision 6375

Added by ben leinfelder almost 13 years ago

include obsoletes and obsoletedBy for system metadata
repurpose the "provenance" table as the ORE mapping table for system metadata

View differences:

upgrade-db-to-1.10.0-postgres.sql
12 12 
	size VARCHAR(256), --the size of the object
13 13 
	replication_allowed boolean,	 -- replication allowed
14 14 
	number_replicas INT8, 	-- the number of replicas allowed
15 
	obsoletes   text,       -- the identifier that this record obsoletes
16 
	obsoleted_by   text,     -- the identifier of the record that replaces this record
15 17 
	CONSTRAINT systemMetadata_pk PRIMARY KEY (guid)
16 18 
);
17 19 
/*
18 
 * Table used to store system metadata provenance information
20 
 * Table used to store system metadata map information
19 21 
 */
20 
CREATE TABLE systemMetadataProvenance (
22 
CREATE TABLE systemMetadataMap (
21 23 
   guid   		text,          -- the globally unique string identifier of the object that the system metadata describes
22 24 
   relationship	VARCHAR(250),	 -- the provenance relationship defined between objects
23 25 
   target_guid	text,          -- the globally unique string identifier of the other object
24 
   CONSTRAINT systemMetadataProvenance_fk
26 
   CONSTRAINT systemMetadataMap_fk
25 27 
		FOREIGN KEY (guid) REFERENCES systemMetadata
26 28 
);
27 29 

  		












Also available in:  Unified diff