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 | ||||
OBSERVATION_ID | The id of the observation this extras product is derived from. | VARCHAR(25) | Pipelines | ||||||
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(28) | Not Null | Pipelines | |||||
VERSION | The version of the product ID that this extras product is associated with. | INT(4) | Not Null | Pipelines | |||||
FILE_TYPE | The type of extras file. See the Extras_File_Types table for the allowed values. | INT(2) unsigned | Foreign Key which references 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 | ||||||
BAND1_STRETCH_MINIMUM | The minimum value of the stretch on band 1. For standard products, this is for the IR band, for rgb products, this is the red channel. | DOUBLE(18,15) | Pipelines | ||||||
BAND1_STRETCH_MAXIMUM | The maximum value of the stretch on band 1. For standard products, this is for the IR band, for rgb products, this is the red channel. | DOUBLE(18,15) | Pipelines | ||||||
BAND2_STRETCH_MINIMUM | The minimum value of the stretch on band 2. For standard products, this is for the RED band, for rgb products, this is the green channel. | DOUBLE(18,15) | Pipelines | ||||||
BAND2_STRETCH_MAXIMUM | The maximum value of the stretch on band 2. For standard products, this is for the RED band, for rgb products, this is the green channel. | DOUBLE(18,15) | Pipelines | ||||||
BAND3_STRETCH_MINIMUM | The minimum value of the stretch on band 3. For standard products, this is for the blue-green band, for rgb products, this is the blue channel. | DOUBLE(18,15) | Pipelines | ||||||
BAND3_STRETCH_MAXIMUM | The maximum value of the stretch on band 3. For standard products, this is for the blue-green band, for rgb products, this is the blue channel. | DOUBLE(18,15) | 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.