Revision 5887
Added by berkley about 13 years ago
| xmltables-postgres.sql | ||
|---|---|---|
| 289 | 289 |
* data first or the systemMetadata first. |
| 290 | 290 |
*/ |
| 291 | 291 |
CREATE TABLE systemMetadata ( |
| 292 |
guid text, -- the globally unique string identifier |
|
| 292 |
guid text, -- the globally unique string identifier of the object that the system metadata describes
|
|
| 293 | 293 |
docid VARCHAR(250), -- the local document id # |
| 294 | 294 |
rev INT8, -- the revision part of the local identifier |
| 295 |
date_uploaded TIMESTAMP, -- the date/time the document was first submitted |
|
| 296 |
rights_holder VARCHAR(250), --the user who has rights to the document, usually the first persons to upload it |
|
| 297 |
checksum VARCHAR(512), --the checksum of the doc using the given algorithm (see below) |
|
| 298 |
checksum_algorithm VARCHAR(250), --the algorithm used to calculate the checksum |
|
| 299 |
origin_member_node VARCHAR(250), --the member node where the document was first uploaded |
|
| 300 |
authoritive_member_node VARCHAR(250), --the member node that currently controls the document |
|
| 301 |
date_modified TIMESTAMP, -- the last date/time that the file was changed |
|
| 302 |
submitter VARCHAR(256), -- the user who originally submitted the doc |
|
| 295 | 303 |
CONSTRAINT systemMetadata_pk PRIMARY KEY (guid) |
| 296 | 304 |
); |
| 297 | 305 |
|
Also available in: Unified diff
adding fields for additional system metadata info