Field |
Description |
Type |
Null |
Limits |
Size |
Key |
Default |
Authority |
Source |
productIdx |
The product index. The values here should correspond to the
released products in the RDR_Products table.
|
INT(11) |
Not Null |
|
|
Primary Key |
|
|
RDR_Products |
productId |
The RDR Product ID
|
VARCHAR(45) |
|
|
|
|
|
|
RDR Products |
dsIdx |
The data set index. This should be a value that exists within the
dsIdx column in the RDR_Datasets table.
|
INT(11) |
Not Null |
|
|
Foreign Key which references RDR_Datasets (dsIdx) ON DELETE CASCADE |
|
|
RDR_Datasets |
volumeId |
The PDS Volume Identifier. At this time, HiRISE is using a single
volumne.
|
VARCHAR(60) |
Not Null |
|
|
|
|
|
Release Tool |
fileName |
The PDS product file name. Excluding any system paths to file.
|
VARCHAR(120) |
Not Null |
|
|
|
|
|
RDR_Products |
filePath |
The logical system path to the product, excluding
the file name.
|
VARCHAR(255) |
Not Null |
|
|
|
|
|
RDR_Products |
thumbnailFile |
The file name of the thumbnail file.
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
browseFile |
The file name of the browse file, excluding the path.
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
sourceThumbnailFile |
The file name of the thumbnail image.
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
sourceBrowseFile |
The file name of the browse file, excluding the path.
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
sourceQuickLookFile |
The file name of the quicklook file, excluding the path.
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
sourceDataFile |
The PDS product file name, excluding the path
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
sourceLabelFile |
The name of the PDS label file, excluding paths. For HiRISE RDR's, the
labels are dettached from the PDS product, so this field should refer to
the actual PDS label file.
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
sourceDisplayFile |
The PDS product file name, excluding the path
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
sourceThumbPath |
The path to the thumbnail file relative to the root of the PDS volume,
excluding the thumbnail file name.
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
sourceBrowsePath |
The path to the browse file relative to the root of the PDS volume,
excluding the browse file name.
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
sourceQuickLookPath |
The path to the quicklook file relative to the root of the PDS volume,
excluding the quicklook file name.
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
sourceDataPath |
The path to the PDS product file relative to the root of the PDS volume,
excluding the product file name.
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
sourceLabelPath |
The path to the PDS label file relative to the root of the PDS volume,
excluding the label file name. While the labels are detached for HiRISE
RDR's, the product file and the label file are located in the directory
path.
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
sourceDisplayPath |
Not currently in use by HiRISE.
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
destThumbPath |
Not currently in use by HiRISE.
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
destBrowsePath |
Not currently in use by HiRISE.
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
destDataPath |
Not currently in use by HiRISE.
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
destLabelPath |
Not currently in use by HiRISE.
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
destDisplayPath |
Not currently in use by HiRISE.
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
errataFile |
TBD
|
VARCHAR(120) |
|
|
|
|
|
|
Release Tool |
LAST_UPDATE |
The last time the record was updated
|
TIMESTAMP |
Not Null |
|
|
|
|
|
db server |
Copyright (C) 2005-2020 Arizona Board of Regents on
behalf of the Planetary Image Research Laboratory,
Lunar and Planetary Laboratory at the University
of Arizona.