Field | Description | Type | Null | Limits | Size | Key | Default | Authority | Source |
---|---|---|---|---|---|---|---|---|---|
ID | A unique record identifying integer. | INT(10) unsigned auto_increment | Not Null | Primary Key | db server | ||||
LEFT_OBSERVATION_ID | The id of the left observation this product is derived from. | VARCHAR(28) | Pipelines | ||||||
RIGHT_OBSERVATION_ID | The id of the right observation this product is derived from. | VARCHAR(28) | DTM procedures | ||||||
PRODUCT_ID | The product ID of the PDS product that the extras product is derived from or associated with. If the extras product is not associated with any official PDS product, then the OBSERVATION_ID should be entered here. | VARCHAR(33) | Not Null | Pipelines | |||||
VERSION | The version of the product ID that this extras product is associated with. | INT(4) | Not Null | Pipelines | |||||
SOURCE_DTM_PRODUCT_ID | The product id of the DTM that this extras product was derived from. | VARCHAR(33) | DTM procedures | ||||||
FILE_TYPE | The type of extras file. See the DTM_Extras_File_Types table for the allowed values. | INT(2) unsigned | Foreign Key which references DTM_Extras_File_Types (ID) ON DELETE SET NULL | Pipelines | |||||
PATHNAME | The full logical path of the extras product, including the file name. | TEXT | Not Null | Pipelines | |||||
PRODUCT_CREATION_TIME | The creation date and time of the extras product. | DATETIME | Pipelines | ||||||
IMAGE_LINES | The number of lines in the image. | INT(11) | Pipelines | ||||||
LINE_SAMPLES | The number of samples per image line. | INT(11) | Pipelines | ||||||
FILE_SIZE | The size of the file in bytes. | INT(11) | Pipelines | ||||||
LAST_UPDATE | This column records the last time the record was updated. | TIMESTAMP | db server |
Table Options:
Copyright (C) 2005-2022 Arizona Board of Regents on behalf of the Planetary Image Research Laboratory, Lunar and Planetary Laboratory at the University of Arizona.
This page was generated from the XML HiCat Data Dictionary. HEAD
Please send comments to: HiCat@pirlmail.lpl.arizona.edu.