/src/xmltables-postgres.sql - Diff - Metacat - Ecoinformatics Redmine

« Previous | Next »

Revision 6375

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

     	size VARCHAR(256), --the size of the object
     	replication_allowed boolean,	 -- replication allowed
     	number_replicas INT8, 	-- the number of replicas allowed
     	obsoletes   text,       -- the identifier that this record obsoletes
     	obsoleted_by   text,     -- the identifier of the record that replaces this record
     	CONSTRAINT systemMetadata_pk PRIMARY KEY (guid)
     );
     /*
-...
      */
     /*
      * Table used to store system metadata provenance information
      * Table used to store system metadata ORE map information
      */
     CREATE TABLE systemMetadataProvenance (
     CREATE TABLE systemMetadataMap (
        guid   		text,          -- the globally unique string identifier of the object that the system metadata describes
        relationship	VARCHAR(250),	 -- the provenance relationship defined between objects
        target_guid	text,          -- the globally unique string identifier of the other object
        CONSTRAINT systemMetadataProvenance_fk
        CONSTRAINT systemMetadataMap_fk
     		FOREIGN KEY (guid) REFERENCES systemMetadata
     );

Also available in: Unified diff