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:

xmltables-postgres.sql
308 308
	size VARCHAR(256), --the size of the object
309 309
	replication_allowed boolean,	 -- replication allowed
310 310
	number_replicas INT8, 	-- the number of replicas allowed
311
	obsoletes   text,       -- the identifier that this record obsoletes
312
	obsoleted_by   text,     -- the identifier of the record that replaces this record
311 313
	CONSTRAINT systemMetadata_pk PRIMARY KEY (guid)
312 314
);
313 315
/*
......
319 321
 */
320 322

  
321 323
/*
322
 * Table used to store system metadata provenance information
324
 * Table used to store system metadata ORE map information
323 325
 */
324
CREATE TABLE systemMetadataProvenance (
326
CREATE TABLE systemMetadataMap (
325 327
   guid   		text,          -- the globally unique string identifier of the object that the system metadata describes
326
   relationship	VARCHAR(250),	 -- the provenance relationship defined between objects
327 328
   target_guid	text,          -- the globally unique string identifier of the other object
328
   CONSTRAINT systemMetadataProvenance_fk 
329
   CONSTRAINT systemMetadataMap_fk 
329 330
		FOREIGN KEY (guid) REFERENCES systemMetadata
330 331
);
331 332

  

Also available in: Unified diff