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-oracle.sql
12 12
   size VARCHAR2(256), --the size of the object
13 13
   replication_allowed boolean,	 -- replication allowed
14 14
   number_replicas NUMBER(8), 	-- the number of replicas allowed
15
   obsoletes   VARCHAR2(2000),    -- the identifier of the record that this replaces
16
   obsoleted_by   VARCHAR2(2000),    -- the identifier of the record that replaces this record
15 17
   CONSTRAINT systemMetadata_pk 
16 18
		PRIMARY KEY (guid)
17 19
)
18 20

  
19 21
/*
20
 * Table used to store system metadata provenance information
22
 * Table used to store system metadata map information
21 23
 */
22
CREATE TABLE systemMetadataProvenance (
24
CREATE TABLE systemMetadataMap (
23 25
   guid   		VARCHAR2(2000),          -- the globally unique string identifier of the object that the system metadata describes
24 26
   relationship	VARCHAR(250),	 -- the provenance relationship defined between objects
25 27
   target_guid	VARCHAR2(2000),          -- the globally unique string identifier of the other object
26
   CONSTRAINT systemMetadataProvenance_fk 
28
   CONSTRAINT systemMetadataMap_fk 
27 29
		FOREIGN KEY (guid) REFERENCES systemMetadata
28 30
);
29 31

  

Also available in: Unified diff