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-oracle.sql
416 416
   size VARCHAR2(256), --the size of the object
417 417
   replication_allowed boolean,	 -- replication allowed
418 418
   number_replicas NUMBER(8), 	-- the number of replicas allowed
419
   obsoletes   VARCHAR2(2000),    -- the identifier of the record that this replaces
420
   obsoleted_by   VARCHAR2(2000),    -- the identifier of the record that replaces this record
419 421
   CONSTRAINT systemMetadata_pk 
420 422
		PRIMARY KEY (guid)
421 423
)
......
423 425
/*
424 426
 * Table used to store system metadata provenance information
425 427
 */
426
CREATE TABLE systemMetadataProvenance (
428
CREATE TABLE systemMetadataMap (
427 429
   guid   		VARCHAR2(2000),          -- the globally unique string identifier of the object that the system metadata describes
428
   relationship	VARCHAR(250),	 -- the provenance relationship defined between objects
429 430
   target_guid	VARCHAR2(2000),          -- the globally unique string identifier of the other object
430
   CONSTRAINT systemMetadataProvenance_fk 
431
   CONSTRAINT systemMetadataMap_fk 
431 432
		FOREIGN KEY (guid) REFERENCES systemMetadata
432 433
);
433 434

  

Also available in: Unified diff