Revision 5887
Added by berkley about 13 years ago
| xmltables-oracle.sql | ||
|---|---|---|
| 402 | 402 |
CREATE TABLE systemMetadata ( |
| 403 | 403 |
guid VARCHAR2(2000), -- the globally unique string identifier |
| 404 | 404 |
docid VARCHAR(250), -- the local document id # |
| 405 |
rev NUMBER(8) -- the revision part of the local identifier |
|
| 405 |
rev NUMBER(8), -- the revision part of the local identifier |
|
| 406 |
date_uploaded DATE, -- the date/time the document was first submitted |
|
| 407 |
rights_holder VARCHAR2(250), --the user who has rights to the document, usually the first persons to upload it |
|
| 408 |
checksum VARCHAR2(512), --the checksum of the doc using the given algorithm (see below) |
|
| 409 |
checksum_algorithm VARCHAR2(250), --the algorithm used to calculate the checksum |
|
| 410 |
origin_member_node VARCHAR2(250), --the member node where the document was first uploaded |
|
| 411 |
authoritive_member_node VARCHAR2(250), --the member node that currently controls the document |
|
| 412 |
date_modified DATE, -- the last date/time that the file was changed |
|
| 413 |
submitter VARCHAR2(256) -- the user who originally submitted the doc |
|
| 406 | 414 |
) |
| 407 | 415 |
|
| 408 | 416 |
/* |
Also available in: Unified diff
adding fields for additional system metadata info