Revision 6098
Added by ben leinfelder almost 13 years ago
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 |
Also available in: Unified diff
add systemMetadataProvenance table for tracking those relationships