Revision 6098
Added by ben leinfelder almost 13 years ago
| 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