Project

General

Profile

Revision 6375

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