Project

General

Profile

« Previous | Next » 

Revision 6098

add systemMetadataProvenance table for tracking those relationships

View differences:

src/xmltables-oracle.sql
415 415
   date_modified DATE, -- the last date/time that the file was changed
416 416
   submitter VARCHAR2(256), -- the user who originally submitted the doc
417 417
   object_format VARCHAR2(256), --the format of the object
418
   size VARCHAR2(256) --the size of the object
418
   size VARCHAR2(256), --the size of the object
419
   CONSTRAINT systemMetadata_pk 
420
		PRIMARY KEY (guid)
419 421
)
420 422

  
421 423
/*
424
 * Table used to store system metadata provenance information
425
 */
426
CREATE TABLE systemMetadataProvenance (
427
   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
   target_guid	VARCHAR2(2000),          -- the globally unique string identifier of the other object
430
   CONSTRAINT systemMetadataProvenance_fk 
431
		FOREIGN KEY (guid) REFERENCES systemMetadata
432
);
433

  
434
/*
422 435
 * Table used to store all document identifiers in metacat.  Each identifier
423 436
 * has a globally unique, unconstrained string, which we will refer to as a
424 437
 * GUID, and a local metacat identifier, which consists of the docid
src/xmltables-postgres.sql
306 306
);
307 307

  
308 308
/*
309
 * Table used to store system metadata provenance information
310
 */
311
CREATE TABLE systemMetadataProvenance (
312
   guid   		text,          -- the globally unique string identifier of the object that the system metadata describes
313
   relationship	VARCHAR(250),	 -- the provenance relationship defined between objects
314
   target_guid	text,          -- the globally unique string identifier of the other object
315
   
316
   CONSTRAINT systemMetadataProvenance_fk 
317
		FOREIGN KEY (guid) REFERENCES systemMetadata
318
);
319

  
320
/*
309 321
 * accesssubtree -- table to store access subtree info
310 322
 */
311 323
CREATE TABLE xml_accesssubtree (

Also available in: Unified diff