Revision 6098
Added by ben leinfelder over 13 years ago
| 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
add systemMetadataProvenance table for tracking those relationships