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:

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